Answers for "mysql first week of the month"

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
1

mysql date of the week

DAYOFWEEK(date)
Posted by: Guest on June-05-2020

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

Code answers related to "SQL"

Browse Popular Code Answers by Language