Skip to content

Instantly share code, notes, and snippets.

@dalmat36

dalmat36/EOMONTH Function

Last active August 29, 2015 13:57
Show Gist options
  • Save dalmat36/9569719 to your computer and use it in GitHub Desktop.
Save dalmat36/9569719 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Server 2012 EOMONTH Function
Raw
EOMONTH Function
/*EOMONTH Function
Example returns the last day of 06/01/2014*/
SELECT EOMONTH('06/01/2014') AS EndofMonth;
/*Example returns the last day of 06/01/2014 + 6months*/
SELECT EOMONTH('06/01/2014',6) AS EndofSixthMonth;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment