Example
Return the year part of a date:
SELECT YEAR("2017-06-15");
Definition and Usage
The YEAR() function returns the year part for a given date (a number from 1000 to 9999).
Syntax
YEAR(date)
Return the year part of a date:
SELECT YEAR("2017-06-15");
The YEAR() function returns the year part for a given date (a number from 1000 to 9999).
YEAR(date)