select format(dateadd(dd,number,'2021-05-01'),'MM月dd日') AS date
from master..spt_values
where type='p' and dateadd(dd,number,'2021-05-01')<='2021-05-10'
开始结束日期之间的全部日期列表
最新推荐文章于 2022-03-29 16:23:47 发布
select format(dateadd(dd,number,'2021-05-01'),'MM月dd日') AS date
from master..spt_values
where type='p' and dateadd(dd,number,'2021-05-01')<='2021-05-10'