CREATE TABLE #DATEInfoFF
(
[every_time] [nvarchar](20) NULL
);
INSERT INTO #DATEInfoFF(every_time)
SELECT
CONVERT (VARCHAR (10), DATEADD(DAY,number,CONVERT(datetime ,'2021-06-01')),120)
FROM
master..spt_values
WHERE
type = 'p'
AND DATEDIFF(MI,DATEADD(DAY,number,CONVERT(datetime , '2021-06-01')), CONVERT(datetime , '2021-07-01')) > 0;
这个表显示了6月份的所有天数