今天的所有数据:select * from 表名 where DateDiff(dd,datetime类型字段,getdate())=0
昨天的所有数据:select * from 表名 where DateDiff(dd,datetime类型字段,getdate())=1
7天内的所有数据:select * from 表名 where DateDiff(dd,datetime类型字段,getdate())<=7
30天内的所有数据:select * from 表名 where DateDiff(dd,datetime类型字段,getdate())<=30
本月的所有数据:select * from 表名 where DateDiff(mm,datetime类型字段,getdate())=0
本年的所有数据:select * from 表名 where DateDiff(yy,datetime类型字段,getdate())=0
select count(1) from BK_KHXX where DateDiff(dd,CreateTime,getdate())=0 --今天
select count(1) from BK_KHXX where DateDiff(dd,CreateTime,getdate())=1 --昨天
select count(1) from BK_KHXX where DateDiff(mm,CreateTime,getdate())=0 --本月
select count(1) from BK_KHXX where DateDiff(mm,CreateTime,getdate())=1 --上月
between Month(GetDate())-6 and Month(GetDate())
between day(‘"&trim(request("sj_from"))&"‘) and day(‘"&trim(request("sj_to"))&"‘)
sql_b="SELECT * FROM BK_KHXX_Record AS t WHERE createtime= (SELECT MIN(createtime) FROM BK_KHXX_Record WHERE CreateID = t.CreateID AND CONVERT(VARCHAR(8) , createtime , 112) = CONVERT(VARCHAR(8) , t.createtime , 112)) and order by createtime desc" --查询按每天的第一条数据
sql_a="select * from BK_KHXX_Record where DelFlag=0 and convert(varchar,createtime,23)=‘"&year(time2) & "-" &right("00"&month(time2),2)& "-" &right("00"&day(time2),2)&"‘ order by RecordTime desc" --按xxxx-0x-0x asp 查询