Answers for "How to get date representing the first day of a month mysql ?"

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';

Posted by: Guest on May-21-2021

Code answers related to "How to get date representing the first day of a month mysql ?"