murillomarigo/monthFirstDay.sql

Created August 8, 2014 14:13

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/murillomarigo/81b38519c33f2be7d04b.js"></script>
Save murillomarigo/81b38519c33f2be7d04b to your computer and use it in GitHub Desktop.

Download ZIP

First day of the current month

Raw

monthFirstDay.sql

SELECT DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0)

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