student_id	fname	lname	day_enrolled	age	username
1	Sky	Towner	2015-12-03	17	stowner1
2	Ben	Davis	2016-04-20	19	bdavis2
3	Travis	Apple	2018-08-14	18	tapple3
4	Arthur	David	2016-04-01	16	adavid4
5	Benjamin	Town	2014-01-01	17	btown5

The above sample table can be created using the code here.

Basic usage

To return last day of the month for each student's enrollment date:


        
        
            
                
                
                    SELECT fname, LAST_DAY(day_enrolled)
FROM students;
                
            
            +----------+------------------------+
| fname    | LAST_DAY(day_enrolled) |
+----------+------------------------+
| Sky      | 2015-12-31             |
| Ben      | 2016-04-30             |
| Travis   | 2018-08-31             |
| Arthur   | 2016-04-30             |
| Benjamin | 2014-01-31             |
+----------+------------------------+

Invalid date input

If the argument is not a valid date, NULL is returned:


        
        
            
                
                
                    SELECT LAST_DAY('2020-04-31');
                
            
            +------------------------+
| LAST_DAY('2020-04-31') |
+------------------------+
| NULL                   |
+------------------------+

The date input is invalid as April only has 30 days.

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

Official MySQL Documentation

https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_last-day

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!