getting number of days in the present month using sql

-- for getting number of days in the present month using sql ------------------------------------

SELECT DAY(DATEADD (m, 1, DATEADD (d, 1 - DAY(GETDATE()), GETDATE())) - 1) As NumDaysInMonth