YEAR[(4)]

A year in 4-digit format. MySQL displays YEAR values in YYYY format,
but permits assignment of values to YEAR columns using either strings
or numbers. Values display as 1901 to 2155, or 0000.

*Note*:

The YEAR(2) data type is deprecated and support for it is removed in
MySQL 5.7.5. To convert 2-digit YEAR(2) columns to 4-digit YEAR
columns, see
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html.

For additional information about YEAR display format and interpretation
of input values, see https://dev.mysql.com/doc/refman/5.7/en/year.html.

URL: https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-syntax.html

