查询日期。

Question

我要实现，查询N天内的所有日期，且是在一张表内。比如查询前5天的所有日期，我希望得到这样一张表  2010-10-4
                                               2010-10-5
                                               2010-10-6
                                               2010-10-7
                                               2010-10-8
请各位大虾不吝赐教~

Answer 1

select dateadd(day,-number-1,getdate()) from master..spt_values where type='P' and number < 5 order by number desc
/*
2010-10-04 16:08:07.487
2010-10-05 16:08:07.487
2010-10-06 16:08:07.487
2010-10-07 16:08:07.487
2010-10-08 16:08:07.487
*/