YEAR

The date function used to return the year value of a date, time, or datetime value.

Parameter	Type
`value`	datetime, date, datetimestamp, gyear, gyearmonth

Returns: integer

query:

SELECT YEAR(CAST("2018-01-02" AS DATE))

results:

year
2,018