- 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 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)
Updated on 29-Jan-2020 05:17:54
- 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?
- Select last day of current year in MySQL?
- How to get the first day of next month in MySQL?
- 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 previous month in MySQL?
- How to get current day, month and year in Java 8?
- Filter the records of current day, month and year in MySQL?
- How to get first and last date of the current month with JavaScript?
- MySQL query to order by current day and month?
- How to get the day of the month in JavaScript?
Advertisements