select Day(getdate())--当前日是这个月的第几天

select YEAR=(select 32-Day(getdate()+(32-Day(getdate()))))--当前月有多少天

select y =(32 - Day(getdate()+(32-Day(getdate()))))-Day(getdate())--当前月还剩多少天