select dateadd(dd,number,'2023-01-01 00:00:00') AS dates from master..spt_values where type='p' and dateadd(dd,number,'2023-01-01 00:00:00')<='2023-02-18 23:59:59'
SQL获取两个日期之间的所有日期
最新推荐文章于 2024-04-07 09:42:12 发布
select dateadd(dd,number,'2023-01-01 00:00:00') AS dates from master..spt_values where type='p' and dateadd(dd,number,'2023-01-01 00:00:00')<='2023-02-18 23:59:59'