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’);
SQL server根据日期范围 返回包含的所有日期
最新推荐文章于 2023-08-10 17:56:12 发布
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’);