Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. SELECT EXTRACT(YEAR FROM 1999-07-02)
mysql>
mysql> SELECT EXTRACT(YEAR FROM '1999-07-02');
+---------------------------------+
| EXTRACT(YEAR FROM '1999-07-02') |
+---------------------------------+
|                            1999 |
+---------------------------------+
1 row in set (0.00 sec)
mysql>