Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. Select YEAR(1973-07-20)
mysql>
mysql> select YEAR('1989-07-20');
+--------------------+
| YEAR('1989-07-20') |
+--------------------+
|               1989 |
+--------------------+
1 row in set (0.00 sec)
mysql>