Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

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>