Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. LAST_DAY(date) returns the corresponding value for the last day of the month
Returns NULL if the argument is invalid.

mysql>
mysql> SELECT LAST_DAY('2003-02-05');
+------------------------+
| LAST_DAY('2003-02-05') |
+------------------------+
| 2003-02-28             |
+------------------------+
1 row in set (0.00 sec)
mysql>