select convert(varchar(10),dateadd(DAY,t2.number,t1.day),120) day from
(select '2016-06'+'-01' day) t1,
(select number from MASTER..spt_values WHERE TYPE='P' AND number>=0 and number<=31) t2
where convert(varchar(10),dateadd(DAY,t2.number,t1.day),120) like '2016-06%'
SQLServer 返回一个月的所有天数
最新推荐文章于 2024-05-11 21:37:06 发布