MySQL LAST_DAY() Function

Extract the last day of the month for the given date:

SELECT LAST_DAY("2017-06-20");

Definition and Usage

The LAST_DAY() function extracts the last day of the month for a given date.

LAST_DAY(date)

Parameter	Description
date	Required. The date to extract the last day of the month from

Works in:	From MySQL 4.0

Extract the last day of the month for the given date:

SELECT LAST_DAY("2017-02-10 09:34:00");