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

MySQLMySQLi Database

With the help of 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)
raja
Published on 19-Feb-2018 07:48:33
Advertisements