时间段查询的问题?急啊在线等啊!
id Atime Btime Cname
1 2007-6-29 10:44:00 2007-6-29 10:50:00 时间查1
2 2007-6-29 11:02:00 2007-6-29 11:20:00 时间查1
怎么用服务器时间查atime到btime所显示的信息
比如现在是2007-6-29 11:12:00
就可以显示出第2条信息
我要怎么写我写的却不对
itime=CDate(Now())
set rs= server.createobject ( "adodb.recordset ")
sql= "select * from SysAds where Atime > ' "&itime& " ' and Btime < ' "&itime& " ' "
rs.open sql,conn,1,1
Response.Write ( "数据库显示： "&rs( "Timefrom ")& "- "&rs( "Timeto ")& " ")
[解决办法]
sql= "select * from SysAds where Atime > ' "&itime& " ' and Btime < ' "&itime& " ' "
sql= "select * from SysAds where datediff(d,atime, ' "&itme& " ') <0 and datediff(d,btime, ' "&itime& " ')> 0
[解决办法]
itime=Now()
set rs= server.createobject ( "adodb.recordset ")
sql= "select * from SysAds where Atime > # "&itime& "# and Btime < # "&itime& "# "
rs.open sql,conn,1,1
Response.Write ( "数据库显示： "&rs( "Atime ")& "- "&rs( "Btime "))
[解决办法]
select * from SysAds where getdate() between Atime and Btime
[解决办法]
我经常用，应该可以的：
sql= "select * from SysAds where DateDiff( 'd ',now,atime)> =0 and DateDiff( 'd ',now,btime) <=0 "
atime和btime应该是时间格式。
[解决办法]
up
