if nowstartdate<>"" then
sql=sql&" and selldate-"&nowstartdate&">=0"
end if
if nowenddate<>"" then
sql=sql&" and selldate-"&nowenddate&"<=0"
end if
selldate为数据库中记录的时间两个时间在这之间的比较
能做这样的比较不。。response.write输出是这样的selldate-2008-3-1>=0 and selldate-2008-3-31<=0发现不能查到一个记录请指导下。
...全文
1539打赏收藏
时间字段的比较,出现问题了?
if nowstartdate"" then sql=sql&" and selldate-"&nowstartdate&">=0" end if if nowenddate"" then sql=sql&" and selldate-"&nowenddate&"=0 and selldate-2008-3-
汗,忘记加'
if nowstartdate <>"" then
sql=sql&" and datediff(day,'"&nowstartdate&"',selldate)>=0"
end if
if nowenddate <>"" then
sql=sql&" and datediff(day,'"&nowenddate&"',selldate)<=0"
end if
response.write sql
response.end
返回的是select * from buy where type=0 and zu=1 and datediff(day,2008-3-1,selldate)>=0 and datediff(day,2008-3-31,selldate)<=0
发现还是查不到。。感觉是数据库字段不对。。数据库中selldate是。。2008-03-28的格式。。在帮忙看看
非常感谢
if nowstartdate <>"" then
sql=sql&" and datediff(day,"&nowstartdate&",selldate)>=0"
end if
if nowenddate <>"" then
sql=sql&" and datediff(day,"&nowenddate&",selldate)<=0"
end if