How to get the first day of last month in MySQL?

With the help of the following MySQL query we can get the first day of the previous month -

mysql> SELECT DATE_FORMAT(CURDATE() - INTERVAL 1 MONTH,'%Y-%m-01') AS 'FIRST DAY OF PREVOIUS MONTH';
+-----------------------------+
| FIRST DAY OF PREVOIUS MONTH |
+-----------------------------+
| 2017-09-01                  |
+-----------------------------+
1 row in set (0.00 sec)

The above is the detailed content of How to get the first day of last month in MySQL?. For more information, please follow other related articles on the PHP Chinese website!