last_day

Description

Syntax

DATE last_day(DATETIME date)

Return the last day of the month, the return day may be : ‘28’(February and not a leap year), ‘29’(February and a leap year), ‘30’(April, June, September, November), ‘31’(January, March, May, July, August, October, December)

example

1. mysql > select last_day('2000-02-03');
2. +-------------------+
3. | last_day('2000-02-03 00:00:00') |
4. +-------------------+
5. | 2000-02-29        |
6. +-------------------+

keywords

1. LAST_DAY,DAYS