declare @startTime datetime,@endTime datetime
set @startTime='2022-05-16 08:00'
set @endTime='2022-05-23 08:00'
SELECT
convert(nvarchar(10), DATEADD(dd,number,@startTime),120) as 日期
FROM master..spt_values WHERE type = 'p' AND DATEDIFF(MI,DATEADD(dd,number,@startTime),@endTime)>0