LAST_DAY(date)

Takes a date or datetime value and returns the corresponding value for the last day of the month. Returns NULL if the argument is invalid or NULL.

Syntax

MYSQL Copy

SELECT LAST_DAY('2003-02-05');
'2003-02-28'
SELECT LAST_DAY('2004-02-05');
'2004-02-29'
SELECT LAST_DAY('2004-01-01 01:01:01');
'2004-01-31'
SELECT LAST_DAY('2003-03-32');
NULL

Examples

Example

MYSQL Copy

SELECT LAST_DAY('2003-02-05');
'2003-02-28'
SELECT LAST_DAY('2004-02-05');
'2004-02-29'
SELECT LAST_DAY('2004-01-01 01:01:01');
'2004-01-31'
SELECT LAST_DAY('2003-03-32');
NULL