Outdated Version

You are viewing an older version of this section. View current production version.


Finds the month of the input date, and then returns a date object containing the last day of that month.

LAST_DAY (dateobj)


  • dateobj: a valid date, datetime, or parsable date string

Return Type

Date object. If dateobj is not a valid date, returns NULL.


memsql> select last_day('2019-01-01 05:06');
| last_day('2019-01-01 05:06') |
| 2019-01-31                   |