mrLexx/first_last_day.sql

Created April 16, 2020 11:06

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/mrLexx/45e41f6fa1dbaebb1c3176eb21dff36a.js"></script>
Save mrLexx/45e41f6fa1dbaebb1c3176eb21dff36a to your computer and use it in GitHub Desktop.

Download ZIP

First and Last day of month on mysql

Raw

first_last_day.sql

select DATE_FORMAT(now(),'%Y-%m-01'),LAST_DAY(now());

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