EOMONTH () Function in SQL Server Denali

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

2011-09-30 00:00:00.000

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

Tags: , ,


Tag cloud