You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.


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                   |

Related Topics