MySQL LAST_DAY Function Examples

MySQL LAST_DAY Function Examples

MySQL LAST_DAY function; In this tutorial, we will demonstrate briefly the MySQL LAST_DAY function with the help of useful examples and it’s syntax.

And as well as, we will take different examples of LAST_DAY function with MySQL like CURDATE(), NOW(), etc.

MySQL provides many dates or time functions here, you will learn LAST_DAY() function of MySQL With CURDATE() OR NOW() a date function.

MySQL LAST_DAY() Function

The MySQL LAST_DAY() is used to returns the last day of the month from a given date. We can pass the DATE OR DATETIME value in this function takes a DATE or DATETIME value.

If you pass the (0000-00-00) value or invalid value in the LAST_DAY() function, it will return null, invalid, NULL.

Syntax

Basic Syntax of LAST_DAY() function is:

LAST_DAY(date)

The date here is the date value that you want the day of the year from which it was returned.

Example-1

Now let’s take an example to explain.

SELECT LAST_DAY('2020-06-18') AS 'Result';

Output-1

+-------------+
| Result      |
+-------------+
| 2020-06-30  |
+-------------+

Example-2

Let’s take another example to explain with a different date.

SELECT LAST_DAY('2018-02-01') AS 'Result';

Output-2

+-------------+
| Result      |
+-------------+
| 2018-02-28  |
+-------------+ 

Example-3 Add Month

In this example, we will get the last day of next month using this function.

We will add one month in current date-time value and pass the value in LAST_DAY() function. It will return on the last day of next month. See the query of the following :

SELECT LAST_DAY(CURDATE() + INTERVAL 1 MONTH);

Output-3

+----------------------------------------+
| LAST_DAY(CURDATE() + INTERVAL 1 MONTH) |
+----------------------------------------+
|  2019-08-31                            |
+----------------------------------------+
1 row in set (0.00 sec) 

Example-4 Using Current Date/Time

Let’s take a new example, we will use the NOW() function with the LAST_DAY() function.

  SELECT 
  NOW(),
  LAST_DAY(NOW());

Output-4

+---------------------+--------------------+
| NOW()               | LAST_DAY(NOW())    |
+---------------------+--------------------+
| 2019-07-12 18:30:44 |   2019-07-31       |
+---------------------+--------------------+

Example-4 With MySQL CURDATE() Function

Let’s take the next example of using CURDATE () function. If you want to know more about CURDATE () function click here.

SELECT 
CURDATE(),
LAST_DAY(CURDATE());    

Output-5

+------------+-----------------------+
| CURDATE()  | LAST_DAY(CURDATE())   |
+------------+-----------------------+
| 2019-07-12 |    2019-07-31         |
+------------+-----------------------+

Example-6 Minus Month

In this example, we will get the last day of the previous month using this function.

We will minus one month in current date-time value and pass the value in LAST_DAY() function. It will return on the last day of the previous month. See the query of the following :

SELECT LAST_DAY(CURDATE() - INTERVAL 1 MONTH);

Output-6

+----------------------------------------+
| LAST_DAY(CURDATE() - INTERVAL 1 MONTH) |
+----------------------------------------+
|  2019-06-30                            |
+----------------------------------------+
1 row in set (0.00 sec) 

Conclusion

Here, you have learned how to use MySQL LAST_DAY() function with various examples.

Recommended MySQL Tutorials

If you have any questions or thoughts to share, use the comment form below to reach us.

AuthorAdmin

My name is Devendra Dode. I am a full-stack developer, entrepreneur, and owner of Tutsmake.com. I like writing tutorials and tips that can help other developers. I share tutorials of PHP, Python, Javascript, JQuery, Laravel, Livewire, Codeigniter, Node JS, Express JS, Vue JS, Angular JS, React Js, MySQL, MongoDB, REST APIs, Windows, Xampp, Linux, Ubuntu, Amazon AWS, Composer, SEO, WordPress, SSL and Bootstrap from a starting stage. As well as demo example.

Leave a Reply

Your email address will not be published. Required fields are marked *