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