select * from yourtable where datediff(day, edate,getdate()) <= 7
用DateDiff比较通用,如果只需以天为计量单位,还可以直接用两个日期相减。DATEDIFF(datepart, startdate, enddate)Datepart的格式表示(可使用的缩写) year yy, yyyy quarter qq, q month mm, m dayofyear dy, y day dd, d week wk, ww hour hh minute mi, n second ss, s millisecond ms 返回整型值。
year yy, yyyy
quarter qq, q
month mm, m
dayofyear dy, y
day dd, d
week wk, ww
hour hh
minute mi, n
second ss, s
millisecond ms 返回整型值。