当月今天至月初的数组
select distinct convert(varchar(10),DATEADD(dd,number,dateadd(mm, datediff(mm, 0, dateadd(dd,-1,getdate())), 0)) ,120) AS cdate
from master.dbo.spt_values
where type='p'
AND number<=DATEDIFF(dd,dateadd(mm, datediff(mm, 0, dateadd(dd,-1,getdate())), 0),dateadd(day,-1,getdate()));
数组
select distinct convert(varchar(10),DATEADD(dd,number,'20160101') ,120) AS cdate
from master.dbo.spt_values
where type='p'
AND number<=DATEDIFF(dd,'20160101','20160331');