LAST_DAY
Finds the month of the input date, and then returns a date object containing the last day of that month.
Syntax
LAST_DAY (dateobj)
Arguments
dateobj: a valid date, datetime, or parsable date string
Return Type
Date object. If dateobj is not a valid date, returns NULL.
Examples
SELECT LAST_DAY('2019-01-01 05:06');
+------------------------------+ | LAST_DAY('2019-01-01 05:06') | +------------------------------+ | 2019-01-31 | +------------------------------+
Related Topics