获取当前月的天数

SELECT 32-DAY(getdate()+32-DAY(getdate()))

 

 

select day(dateadd(mm,1,getdate())-day(getdate()))