Skip to content

Instantly share code, notes, and snippets.

@mrLexx

mrLexx/first_last_day.sql

Created April 16, 2020 11:06
Show Gist options
  • Save mrLexx/45e41f6fa1dbaebb1c3176eb21dff36a to your computer and use it in GitHub Desktop.
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