Syntax:
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.

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

