--截止日前某个月份的所有日期(查2019-04月份)
--某个月份的所有日期
BEGIN
declare @now as varchar(12)
declare @nowdate as date
set @nowdate = GETDATE()
IF @nowdate>='2019-04-30'
set @now='2019-04-30'
ELSE
set @now=CONVERT(char(10),@nowdate,12)
SELECT CONVERT(char(10),DateAdd(day,number,'2019-04-01'),120) allDay
FROM master..spt_values
WHERE type = 'p'
AND number <= DateDiff(day,'2019-04-01',@now)
END
结果只显示到现在日期: