Loading lesson path
Concept visual
Start at both ends
Extract the last day of the month for the given date:
SELECT LAST_DAY("2017-06-20");The LAST_DAY() function extracts the last day of the month for a given date.
LAST_DAY( date )
Required. The date to extract the last day of the month from
From MySQL 4.0
Extract the last day of the month for the given date: SELECT LAST_DAY("2017-02-10 09:34:00");
❮ MySQL Functions