我用
SET @[email protected]+' and datediff(Week , begintime , getdate()) >= 0 and datediff(Week ,endtime , getdate())<= 0'
可以查询到本周的记录.
如果要查询昨天,上周,上月,去年的记录应该如何做?
谢谢好心人.
------解决方案--------------------
上周SET @[email protected]+ ' and datediff(Week , begintime , getdate()) =1
上月SET @[email protected]+ ' and datediff(month, begintime , getdate()) =1
去年SET @[email protected]+ ' and datediff(year, begintime , getdate()) =1
------解决方案--------------------
如果要查询昨天,上周,上月,去年的记录应该如何做?
上周
select * from tb where datediff(week,日期,getdate()) = 1
上月
select * from tb where datediff(month,日期,getdate()) = 1
去年
select * from tb where datediff(year,日期,getdate()) = 1
------解决方案--------------------
ls都是正解！