by Amol
22. September 2011 09:52
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.