Answers for "mysql first week of the month"

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

mysql date of the week

DAYOFWEEK(date)

Posted by: Guest on June-05-2020

Code answers related to "mysql first week of the month"