THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL LAST_DAY() Function

❮ MySQL Functions

Example

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

SELECT LAST_DAY("2017-06-20");
Try it Yourself »

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");
Try it Yourself »

❮ MySQL Functions