LAST_DAY

Returns a date that represents the last day of the month indicated by datetime-expression.

Example:

  SELECT LAST_DAY('2000-04-24')
FROM EMPLOYEE

Returns '2000-04-30,' which is the last day of April.