Returns the year component of the TIMESTAMP argument.
YEAR( timestamp-expression )
timestamp-expression A TIMESTAMP value.
SMALLINT
The value returned is the years component of the given TIMESTAMP value, returned as a SMALLINT.
SQL/2008 Vendor extension.
The following example returns the value 2001.
SELECT YEAR( '2001-09-12' );