Question

asp命令如何查询access数据库中昨天或前天的数据？

asp命令如何查询access数据库中昨天或前天的数据？

Answer 1

给你看个例子
sj_1是你数据库中的时间

function cnmaisj(sj_1)
dim sj
sj=DateDiff("D",sj_1,now())
if sj<1 then
response.write "<font color=""#FF0000"">今天</font><img src=""image/news.gif"">"
elseif sj<2 and sj>=1 then
response.write "<font color=""#0000FF"">昨天"&timevalue(sj_1)&"</font>"
elseif sj>=2 and sj<3 then
response.write "<font color=""#008080"">前天"&timevalue(sj_1)&"</font>"
elseif sj>=3 then
response.write "<font color=#353535>"&datevalue(sj_1)&"</font>"
end if
end function