version 11
YEAR (arithmetic_expression)
Description
The YEAR function returns the year part of the date passed in the arithmetic_expression.
Example
Supposing that we have the PEOPLE table with a Date_of_Birth field. To find out the year of the date of birth for every person in PEOPLE :
SELECT YEAR(Date_of_Birth) FROM PEOPLE;See Also