Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. YEAR(date) returns the year for date, in the range 1000 to 9999, or 0 for the zero date
mysql>
mysql> SELECT YEAR('98-02-03');
+------------------+
| YEAR('98-02-03') |
+------------------+
|             1998 |
+------------------+
1 row in set (0.00 sec)
mysql>