SELECT CONVERT(varchar(100), DATEADD(dd, number, '2020-12-01'),23) AS 日期
FROM master.dbo.spt_values
WHERE type = 'p'
AND number <= DATEDIFF(DAY, '2020-12-01', '2020-12-16')
master.dbo.spt_values是MySQL中内置的,上述命令可以直接执行,更具实际需求,修改代码即可
SELECT CONVERT(varchar(100), DATEADD(dd, number, '2020-12-01'),23) AS 日期
FROM master.dbo.spt_values
WHERE type = 'p'
AND number <= DATEDIFF(DAY, '2020-12-01', '2020-12-16')
master.dbo.spt_values是MySQL中内置的,上述命令可以直接执行,更具实际需求,修改代码即可