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

Related posts:

  1. Contact Us
  2. Send email using smtp server.
  3. What is Format Function in SQL Server?
  4. What is DATEFROMPARTS Function in SQL Server?

1 thought on “What is Eomonth Function in SQL Server?”

Comments are closed.