SQL Server获取日期段内所有日期列表

declare @date_begin date = '2022-01-01'
declare @date_end date = '2022-01-20'
select convert(varchar(20), dateadd(day, n.number, @date_begin), 23) date_list
from master..spt_values n
where n.type = 'p'
and n.number <= datediff(day, @date_begin, @date_end)
执行结果如下:
140-SQL Server获取日期段内所有日期列表
 直接给值获取:
select convert(varchar(20), dateadd(day, n.number, '2022-01-01'), 23) date_list
from master..spt_values n
where n.type = 'p'
and n.number <= datediff(day, '2022-01-01', '2022-01-20')