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
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
转载于:https://www.cnblogs.com/connlyn/archive/2012/02/06/2339737.html