Syntax error How to get the first day of the previous month in MySQL?

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

With the help of following MySQL query, we can get the first day of 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)
Updated on: 2020-01-29T05:19:15+05:30

3K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements