How to get last date of a month using sql query

Below statement will return the last date of the current month:

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