What is Eomonth Function in SQL Server?


Eomonth Function comes with SQL Server 2012. This function is used to get last date of the month with given date.
Syntax:
Eomonth (date)
Example:

Select Eomonth(Getdate()) as LastDateOfMonth


Result:
2015-06-30

One thought on “What is Eomonth Function in SQL Server?

Comments are closed.