Returns the year based on the year field in date_exp as an integer value. The range is data source-dependent.

 

Example:

SELECT YEAR({d '2001-09-13'}) returns 2001