当前日期后10天日期 

select convert(varchar(10),dateadd(day,number,dateadd(day,-9,getdate())),120) as [date] from master..spt_values 
where datediff(day,dateadd(day,number,dateadd(day,-9,getdate())),getdate())>=0 and number>=0 and type='p'

 

posted @ 2017-07-05 11:28  hllive  阅读(218)  评论(0)  编辑  收藏  举报