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

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

mysql> SELECT LAST_DAY(now()) AS 'LAST DAY OF CURRENT MONTH';
+---------------------------+
| LAST DAY OF CURRENT MONTH |
+---------------------------+
| 2017-10-31                |
+---------------------------+
1 row in set (0.00 sec)

Sravani S

Published on 19-Feb-2018 07:55:39

• Related Questions & Answers
• How to get last day of the previous month in MySQL?
• How to get last day of the next month in MySQL?
• How to get the first day of the current month in MySQL?
• Get the last day of month in Java
• 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
• Select last day of current year in MySQL?
• How to get the first day of next month in MySQL?
• How to display first day and last day of the month from date records in MySQL?
• How to get the first day of the previous month in MySQL?
• Filter the records of current day, month and year in MySQL?
• How to get current day, month and year in Java 8?
• How to get first and last date of the current month with JavaScript?
• How to get the day of the month in JavaScript?
• MySQL query to order by current day and month?