怎么用sql列出最近7天的日期

[blacklevin]

查询结果是
2006-11-17
2006-11-18
2006-11-19
2006-11-20
2006-11-21
2006-11-22
2006-11-23

[caixia615]

select 时间 from tablename where datedeff(day,'时间',getdate())<=7

[青锋-SS]

楼上正解.

[CSDMN]

select dateadd(day,-d,convert(varchar(8),getdate(),112)) as dt
from (
select 0 as d
union all
select 1
union all
select 2
union all
select 3
union all
select 4
union all
select 5
union all
select 6
) as t

[dulei115]

select convert(varchar(10), dateadd(day, n, getdate()), 120) as 日期
from (select -6 as n union select -5 union select -4 union select -3
union select -2 union select -1 union select 0) a


日期
----------
2006-11-17
2006-11-18
2006-11-19
2006-11-20
2006-11-21
2006-11-22
2006-11-23

（所影响的行数为 7 行）

[中国风]

楼主只是想看一下效果，只有根据getdate()来实现
如果要处理数据
select 日期=convert(varchar(10),时间,120)
from tablename
where DATEDIFF(day,时间,getdate())<7