--某个月份的所有日期
SELECT CONVERT(char(10),DateAdd(day,number,'2019-03-01'),120) allDay
FROM master..spt_values
WHERE type = 'p'
AND number <= DateDiff(day,'2019-03-01','2019-03-31')
结果如下:
--某个月份的所有日期
SELECT CONVERT(char(10),DateAdd(day,number,'2019-03-01'),120) allDay
FROM master..spt_values
WHERE type = 'p'
AND number <= DateDiff(day,'2019-03-01','2019-03-31')
结果如下: