----得到当前月的总天数 ① select day(dateadd(mm,1,GETDATE())-day(GETDATE())) ② SELECT 32-DAY(getdate()+32-DAY(getdate()))