YEAR function [Date and time]

Returns a four digit number corresponding to the year of the given date/time.

YEAR ( datetime-expression )

The following statement returns the value 1998:

SELECT YEAR( '1998-07-13 06:07:12' ) FROM iq_dummy

The YEAR function is the same as the first syntax of the YEARS function.