How to find out first day of the month in mysql

You can find out first day of the month using this query.

SELECT DATE_FORMAT(NOW() ,'%Y-%m-01') 

Result: