34,590
社区成员
发帖
与我相关
我的任务
分享
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
*/