SQLcommitted

Sql Server 2012 function EOMONTH()

It returns the last day of the month for the given date with an optional offset.

Syntax : EOMONTH ( start_date [, month_to_add ] )

It returns date type.

Example 1:

DECLARE @date DATETIME
SET @date = ’12/1/2011′
SELECT EOMONTH ( @date) AS LastDateOfTheMonth
GO

Output :

Example 2: Using offset

DECLARE @date DATETIME
SET @date = ’12/1/2011′
SELECT EOMONTH ( @date, 1) AS LastDateOfTheMonth
GO

Output:

April 5, 2012 Posted by SQLcommitted | SQL SERVER 2012 | End Of Month, EOMONTH | Leave a Comment