- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 29-Jan-2020 05:11:19
- 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?
- Convert day of year to day of month in Java
- How to get day of month, day of year and day of week in android using offset date time API class?
Advertisements