sshaffer/SQL-Date-Times.SQL

Created September 28, 2017 13:30

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/sshaffer/5477e98c4d11863b3508ca37ef8f2c72.js"></script>
Save sshaffer/5477e98c4d11863b3508ca37ef8f2c72 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

SQL-Date-Times.SQL

	--YEAR First of Month YYYY-MM-01 Format
	DATEADD(MONTH, DATEDIFF(MONTH, 0, [date_column]), 0) AS YearMonth

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment