How to get first day of every corresponding month in mysql? May 9, 2023 by Tarik Is this what you are looking for: select CAST(DATE_FORMAT(NOW() ,'%Y-%m-01') as DATE);