Syntax error How to get last day of the next month in MySQL?

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

With the help of following MySQL query, we can get the last day of next month −

mysql> SELECT LAST_DAY(now() + INTERVAL 1 MONTH) AS 'LAST DAY OF NEXT
MONTH';
+------------------------+
| LAST DAY OF NEXT MONTH |
+------------------------+
| 2017-11-30             |
+------------------------+
1 row in set (0.00 sec)
Updated on: 2020-01-29T05:11:19+05:30

383 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements