SELECT CONVERT(VARCHAR(10), DATEADD(dd, number, '2015-10-25'), 120) AS dtDate
FROM master..spt_values
WHERE type = 'P' AND DATEADD(dd, number, '2015-10-25') < '2015-11-10'
11:20:45
这个是关键所在
select CONVERT(VARCHAR(10), DATEADD(dd, number, '2015-10-25'), 120),number
from master..spt_values WHERE type = 'P'
FROM master..spt_values
WHERE type = 'P' AND DATEADD(dd, number, '2015-10-25') < '2015-11-10'
11:20:45
这个是关键所在
select CONVERT(VARCHAR(10), DATEADD(dd, number, '2015-10-25'), 120),number
from master..spt_values WHERE type = 'P'
SELECT DATEADD(DAY, number, CONVERT(DATETIME, '2018-02-01')) [DataTime]
FROM master..spt_values
WHERE type = 'P'
AND number
BETWEEN 0 AND DATEDIFF(DAY, '2018-02-01', DATEADD(MONTH, 1, '2018-03-01'))-1;