MySQL Function Reference

YEAR

Returns the year for a specified date

MySQL 8.1

YEAR(datetime)

Examples

MySQL 8.1

SELECT YEAR("2022-06-16");