本周:select * from table where datediff(week,C_CALLTIME,getdate())=0 --C_CALLTIME 为日期字段
本月:select * from table where datediff(Month,C_CALLTIME,getdate())=0 --C_CALLTIME 为日期字段
本季:select * from table where datediff(qq,C_CALLTIME,getdate())=0
前半年1-6,后半年7-12:select * from table where datepart(mm,C_CALLTIME)/7 = datepart(mm,getdate())/7
sql本周热点, sql 本周数据查询:
select top 5 * from table where addtime between dateadd('d',-weekday(date()),date()) and date() order by hits desc,id desc
date = "2003-06-08"
date = dateadd("d",-(Weekday(date,vbMonday)-1),date)
查询本周,其他的类似:
Select * from table where t_date 〉= date and t_date 〈 dateadd("d",8,date)
Select * from table where t_date 〉= cdate("2003-06-08")and t_date 〈= cdate("2003-06-14")
我写的查询语句。可行.. ,适合中国的星期算法!
select top 5 * from table where addtime between dateadd(’d’,-weekday(date()),date()) and date() order by hits desc,id desc