Example

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.

Syntax

LAST_DAY(date)

Parameter Values

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

Technical Details

Works in: From MySQL 4.0

More Examples

Example

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

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


Login
ADS CODE