LAST_DAY Use LAST_DAY to return the last day of the month associated with a date or datetime. Syntax LAST_DAY(date_expression)