gcleaves/mysql_date_trunc

Forked from mtrbean/mysql_date_trunc

Last active August 26, 2015 16:12

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/gcleaves/9df6d94ce0062c8eafb7.js"></script>
Save gcleaves/9df6d94ce0062c8eafb7 to your computer and use it in GitHub Desktop.

Download ZIP

MySQL date_trunc equivalent

Raw

mysql_date_trunc

	DATE_TRUNC('week', now()) === STR_TO_DATE(CONCAT(YEARWEEK(now(), 2), ' Sunday'), '%X%V %W')
	DATE_TRUNC('month', now()) === DATE_FORMAT(now(), '%Y-%m-01')

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