Example
Return the year part of a date:
SELECT YEAR('2017/08/25') AS Year;
Definition and Usage
The YEAR() function returns the year part for a specified date.
Syntax
YEAR(date)
Return the year part of a date:
SELECT YEAR('2017/08/25') AS Year;
The YEAR() function returns the year part for a specified date.
YEAR(date)