declare @diff int
,@firstDay datetime= dateadd(year, datediff(year, 0, getdate()), 0)
,@lastDay datetime= dateadd(year, datediff(year, 0, dateadd(year, 1, getdate())), -1)
select @diff= datediff(day,@firstDay,@lastDay)
select convert(varchar(10),dateadd(DAY,t2.number,t1.day),120) daySA
from
(select @firstDay day) t1,
(select number from MASTER..spt_values WHERE TYPE='P' AND number>=0 and number<=@diff) t2
where dateadd(DAY,t2.number,t1.day)<'2023/4/1'
【无标题】sql server 查询当年的所有日期
最新推荐文章于 2023-07-27 16:03:10 发布