日期相关语句

1、求本月天数过程

select getdate()当前日期select day(getdate())当前第n天select getdate()-day(getdate())上月最后一天select dateadd(MM,1,getdate())-day(getdate())本月最后一天select day(dateadd(mm,1,getdate())-day(getdate()))本月天数