Home>Article>Database> How to get the last day of the month in MySQL?

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

WBOY
WBOY forward
2023-09-18 08:53:05 1023browse

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

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

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

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete