Name

YEAR()

Synopsis

YEAR(date)

Returns the year for date in the range 1000 to 9999, or 0 for the zero date. This code returns the value 1999:

SELECT YEAR('1999-08-07');