Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. YEAR(date) returns the 4-digit numeric year of a given date
mysql>
mysql> SELECT YEAR('01/12/25 11:00:00');
+---------------------------+
| YEAR('01/12/25 11:00:00') |
+---------------------------+
|                      2001 |
+---------------------------+
1 row in set (0.00 sec)
mysql>