--sqlserver 输出两个日期中间的所有日期
DECLARE @start DATE = '2020-7-1',@end DATE='2020-7-10'
select DATEADD(DAY,number,@start) [days] from master..spt_values where type='p' AND number<=DATEDIFF(day,@start,@end)
输出结果
--sqlserver 输出两个日期中间的所有日期
DECLARE @start DATE = '2020-7-1',@end DATE='2020-7-10'
select DATEADD(DAY,number,@start) [days] from master..spt_values where type='p' AND number<=DATEDIFF(day,@start,@end)
输出结果