YEAR (date_exp)

Returns the year as an integer value. The range depends on the data source. Date_exp can be a DATE, TIMESTAMP literal, or a column containing DATE, TIMESTAMP, or DATETIME data.
Thursday, 18 April 2019 Posted in Time and Date Functions