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)

Ramu Prasad

Published on 19-Feb-2018 08:02:18

• Related Questions & Answers
• How to get the first day of next month in MySQL?
• How to get last day of the current month in MySQL?
• How to get last day of the previous month in MySQL?
• Get the last day of month in Java
• Get the first and last date of next month in MySQL?
• How to get last day of a month in Python?
• Java Program to get day of week for the last day of each month in 2019
• How to display first day and last day of the month from date records in MySQL?
• How to get the first day of the current month in MySQL?
• How to get the first day of the previous month in MySQL?
• How to get the day of the month in JavaScript?
• How to get first day of every corresponding month in MySQL?
• MySQL query to get next closest day between two days?
• Python Pandas - Indicate whether the date in DateTimeIndex is the last day of the month
• Convert day of year to day of month in Java