Answers for "current day or current month at first mysql"

SQL
1

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 "current day or current month at first mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language