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

With the help of the following MySQL query we can get the last day of the 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)

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