日期:2014-05-18 浏览次数:20448 次
select * from 表1 where datediff(wk,time,getdate()) <= 7
select * from 表1 where datediff(dd,time,getdate()) <= 7 ------解决方案--------------------select * from 表1 where time >= dateadd(day,-7,getdate())