sql 判断字段日期和特定日期的大小
2017-02-26 08:38 写代码的渔夫 阅读(2810) 评论(0) 编辑 收藏 举报sql 判断字段日期和特定日期的大小
'查找用户
dim fenPeople,fenMoney
set rs=Server.CreateObject("ADODB.recordset")
'列出和自己同期的所有玩家
sql="select
* from user_info where user_level>0 and datediff('s',gameOverDate,'"
& fenLast & "')<=0 and datediff('s',gameOverDate,'" &
fenThis & "')>=0 and datediff('s',ipDate,'" & date()&"
23:59:59" & "')>=0 and datediff('s',ipDate,'" & date()&"
00:00:01" & "')<=0 order by ipNumToday desc"
rs.open sql,conn,1,1