select datediff(d, (datename(yyyy, getdate()) + '/' + datename(mm, getdate()) + '/01'), (datename(yyyy, getdate()) + '/' + cast((datepart(mm, getdate()) + 1) as varchar) + '/01'));
TSQL取得当前月有多少天
最新推荐文章于 2022-01-19 09:20:29 发布
select datediff(d, (datename(yyyy, getdate()) + '/' + datename(mm, getdate()) + '/01'), (datename(yyyy, getdate()) + '/' + cast((datepart(mm, getdate()) + 1) as varchar) + '/01'));