EOMONTH () Function in SQL Server Denali

SQL Server Denali introduced new function EOMONTH() to calculate End Of Month date

SELECT EOMONTH (GETDATE()) LastDayOfMonth  -- Will return last day of the month

LastDayOfMonth
-------------------------
2011-09-30 00:00:00.000

In earlier version we need to many date time function to the last day of the month.