MySQL LAST_DAY() Function — SQL

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

sql

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

Definition and Usage

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

text

  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:

sql

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