22,210
社区成员
发帖
与我相关
我的任务
分享
select convert(char(10),dateadd(d,number,'2010-10-01'),120) from master..spt_values where type='p' and dateadd(d,number,'2010-10-01')<'2010-11-02'
select dateadd(d,number,'2010-10-01') from master..spt_values where type='p' and dateadd(d,number,'2010-10-01')<'2010-11-02'