SQL•SQL References

MySQL LAST_DAY() Function

Example

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

Definition and Usage

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

Syntax

LAST_DAY(
date
)

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

Works in:	From MySQL 4.0

Loading lesson path

SQL•SQL References

Example

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

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

Syntax

LAST_DAY(
date
)

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

Works in:	From MySQL 4.0