select convert(char(10),CAST(CONVERT(varchar(7),'2021-10-22')+'-'+CONVERT(VARCHAR(2),number+1) AS datetime),120) date_time
from master..spt_values
where type='p' and DATEADD(day,number, cast(CONVERT(varchar(7),'2021-10-22')+'-01' as datetime))<DATEADD(MONTH,1,cast(CONVERT(varchar(7),'2021-10-22')+'-01' as datetime))
sqlserver 查询当月每日的sql
最新推荐文章于 2024-07-03 07:04:23 发布