SELECT LAST_DAY('2004-01-01 01:01:01'); : LAST_DAY « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. LAST_DAY
mysql>
mysql> SELECT LAST_DAY('2004-01-01 01:01:01');
+---------------------------------+
| LAST_DAY('2004-01-01 01:01:01') |
+---------------------------------+
| 2004-01-31                      |
+---------------------------------+
1 row in set (0.00 sec)

mysql>








14.23.LAST_DAY
14.23.1.LAST_DAY(date) returns the corresponding value for the last day of the month.
14.23.2.SELECT LAST_DAY('2004-02-05');
14.23.3.SELECT LAST_DAY('2004-01-01 01:01:01');
14.23.4.SELECT LAST_DAY('2003-03-32');