{"id":6299,"date":"2017-07-13T20:42:22","date_gmt":"2017-07-14T03:42:22","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=6299"},"modified":"2023-10-16T19:04:51","modified_gmt":"2023-10-17T02:04:51","slug":"mysql-last_day","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-date-functions\/mysql-last_day\/","title":{"rendered":"MySQL LAST_DAY() Function"},"content":{"rendered":"
\n
\"MySQL<\/figure>\n<\/div>\n\n\n

Summary<\/strong>: This tutorial introduces you to the MySQL LAST_DAY()<\/code> function and shows you how to apply the LAST_DAY()<\/code> function in various contexts.<\/p>\n\n\n\n

Introduction to MySQL LAST_DAY() function<\/h2>\n\n\n\n

The LAST_DAY()<\/code> function takes a DATE<\/code><\/a> or DATETIME<\/code><\/a> value and returns the last day of the month for the input date:<\/p>\n\n\n

LAST_DAY(date);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The date argument must be a valid DATE<\/code> or DATETIME<\/code> value.<\/p>\n\n\n\n
MySQL LAST_DAY() function examples<\/h2>\n\n\n\n
Let’s take some examples of using the LAST_DAY()<\/code> function.<\/p>\n\n\n\n
1) MySQL LAST_DAY() simple example<\/h3>\n\n\n\n
The following example uses the LAST_DAY()<\/code> function to return the last day of February 03, 2016<\/code>.<\/p>\n\n\n
SELECT<\/span> LAST_DAY<\/span>('2016-02-03'<\/span>);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Here is the output:<\/p>\n\n\n
+------------------------+<\/span>\n| LAST_DAY('2016-02-03') |\n+------------------------+<\/span>\n| 2016-02-29             |\n+------------------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
2) Using LAST_DAY()  function to get the last day of the current month<\/h3>\n\n\n\n
To get the last day of the current month, you combine the LAST_DAY()<\/code> function with the NOW()<\/a><\/code> or CURDATE()<\/a><\/code> function as follows:<\/p>\n\n\n
SELECT<\/span> LAST_DAY<\/span>(NOW<\/span>());<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The output is:<\/p>\n\n\n
+-----------------+\n| LAST_DAY(NOW()) |\n+-----------------+\n| 2017<\/span>-07<\/span>-31<\/span>      |\n+-----------------+\n1<\/span> row in<\/span> set<\/span> (0.00 sec)<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n
SELECT<\/span> LAST_DAY<\/span>(CURDATE<\/span>());<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n
+---------------------+\n| LAST_DAY(CURDATE()) |\n+---------------------+\n| 2017<\/span>-07<\/span>-31<\/span>          |\n+---------------------+\n1<\/span> row in<\/span> set<\/span> (0.00 sec)<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
3) Using the LAST_DAY() function to get the last day of the next month<\/h3>\n\n\n\n
To get the last day of the next month, you add 1 month to the current date and pass the result to the LAST_DAY()<\/code> function as shown in the following query:<\/p>\n\n\n
SELECT<\/span> LAST_DAY<\/span>(CURDATE<\/span>() + INTERVAL<\/span> 1<\/span> MONTH<\/span>);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Here is the output:<\/p>\n\n\n
+----------------------------------------+\n| LAST_DAY(CURDATE() + INTERVAL 1<\/span> MONTH) |\n+----------------------------------------+\n| 2017<\/span>-08<\/span>-31<\/span>                             |\n+----------------------------------------+\n1<\/span> row in<\/span> set<\/span> (0.00 sec)<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
4) Getting the first day of the month for a date<\/h3>\n\n\n\n
MySQL does not have a function that returns the first day of a date. However, you can use the LAST_DAY()<\/code> function to calculate it by using these steps:<\/p>\n\n\n\n
The LAST_DAY()<\/code> function returns NULL<\/a><\/code> if the date is zero ( 0000-00-00<\/code>), invalid, or NULL<\/code>.<\/p>\n\n\n\n