Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

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

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