Answers for "first day of date 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 "first day of date mysql"