select * from 表 where datediff(day,时间字段,getdate())<=7--七天之内 select * from 表 where datediff(day,时间字段,getdate())<=datepart(weekday,getdate())--本周