MySQL Tutorial/Date Time Functions/YEAR

select YEAR("1973-07-20");

   <source lang="sql">

mysql> mysql> mysql> select YEAR("1989-07-20"); +--------------------+ | YEAR("1989-07-20") | +--------------------+ | 1989 | +--------------------+ 1 row in set (0.00 sec) mysql></source>

YEAR(date) returns the 4-digit numeric year of a given date:

   <source lang="sql">

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></source>

YEAR(date) returns the year for date, in the range 1000 to 9999, or 0 for the "zero" date.

   <source lang="sql">

mysql> mysql> SELECT YEAR("98-02-03"); +------------------+ | YEAR("98-02-03") | +------------------+ | 1998 | +------------------+ 1 row in set (0.00 sec) mysql></source>