ms sqlserver 查询今天，昨天，最近7天，最近一个月的记录

 select * from Works  where datediff(d,AddTime,getdate())<0 

 select * from Works  where datediff(d,AddTime,getdate())<1

 select * from Works  where datediff(d,AddTime,getdate())<7 

 select * from Works  where datediff(d,AddTime,getdate())<30