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

With the help of the following MySQL query, we can get the first day of the current month −

mysql> SELECT DATE_SUB(LAST_DAY(NOW()),INTERVAL DAY(LAST_DAY(NOW()))-
1 DAY) AS 'FIRST DAY OF CURRENT MONTH';
+----------------------------+
| FIRST DAY OF CURRENT MONTH |
+----------------------------+
| 2017-10-01                 |
+----------------------------+
1 row in set (0.00 sec)

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