mysql next month first day code example
Example 1: mysql get last day of month
SELECT LAST_DAY(CURDATE()); -- Current month
SELECT LAST_DAY(CURDATE() - INTERVAL 1 MONTH); -- Previous month
SELECT LAST_DAY(CURDATE() + INTERVAL 1 MONTH); -- Next month
Example 2: mysql first day of month
-- Replace curdate() with your date column
SELECT curdate(),
DATE_SUB( curdate(), INTERVAL DAYOFMONTH(curdate())-1 DAY ) AS '1st of month';