都不是,在asp文件中调用 select * from table where datediff(d,dt,getdate())<=30 可以得到结果的
ymda=cdate(request("ymda")) ymdb=cdate(request("ymdb")) rs.open "select * from guess where uid='"&tag&"' and '"&datediff(d,ymda,dt)&"'>=0 and '"&datediff(d,dt,ymdb)&"'>=0 order by dt desc",,1,2 想得到在时间段内的数据记录
一种: ymda=cdate(request("ymda")) ymdb=cdate(request("ymdb"))rs.open "select * from guess where uid='" & Tag & "' and'" & " dt BETWEEN '" & Format(ymda, "yyyy/mm/dd") & "' AND '" & Format(ymdb, "yyyy/mm/dd") & "' order by dt desc", , 1, 2 rs.open "select * from guess where uid='" & Tag & "' and'" & " dt BETWEEN '" & Format(ymda, "yyyy/MM/dd hh:mm:ss") & "' AND '" & Format(ymdb, "yyyy/MM/dd hh:mm:ss") & "' order by dt desc", , 1, 2或者rs.open "select * from guess where uid='" & Tag & "' and " & " DateDiff(d,convert(datetime,'" & Format(ymda, "yyyy/mm/dd") & "'),dt)>=0 " & " and DateDiff(d,dt,convert(datetime,'" & Format(ymdb, "yyyy/mm/dd") & "'))>=0 order by dt desc", , 1, 2
补充:也可以使用(SQL形式)select * from guess where uid='001' and dt>='2000/1/1' and dt<='2000/2/1'
select * from table where datediff(d,dt,getdate())<=30
可以得到结果的
ymdb=cdate(request("ymdb"))
rs.open "select * from guess where uid='"&tag&"' and
'"&datediff(d,ymda,dt)&"'>=0 and '"&datediff(d,dt,ymdb)&"'>=0 order by dt desc",,1,2
想得到在时间段内的数据记录
ymda=cdate(request("ymda"))
ymdb=cdate(request("ymdb"))rs.open "select * from guess where uid='" & Tag & "' and'" & " dt BETWEEN '" & Format(ymda, "yyyy/mm/dd") & "' AND '" & Format(ymdb, "yyyy/mm/dd") & "' order by dt desc", , 1, 2
rs.open "select * from guess where uid='" & Tag & "' and'" & " dt BETWEEN '" & Format(ymda, "yyyy/MM/dd hh:mm:ss") & "' AND '" & Format(ymdb, "yyyy/MM/dd hh:mm:ss") & "' order by dt desc", , 1, 2或者rs.open "select * from guess where uid='" & Tag & "' and " & " DateDiff(d,convert(datetime,'" & Format(ymda, "yyyy/mm/dd") & "'),dt)>=0 " &
" and DateDiff(d,dt,convert(datetime,'" & Format(ymdb, "yyyy/mm/dd") & "'))>=0 order by dt desc", , 1, 2