Syntax\n------\n\nYEAR[(4)]\n\nDescription\n-----------\n\nA year in four-digit format. The two-digit format, while supported, is error-prone and deprecated since 2012.\n\nIn four-digit format, the allowable values are 1901 to 2155, and 0000. In two-digit format, the allowable values are 70 to 69, representing years from 1970 to 2069. MariaDB displays YEAR values in YYYY format, but allows you to assign values to YEAR columns using either strings or numbers.\n\nInserting numeric zero has a different result for YEAR(4) and YEAR(2). For YEAR(2), the value 00 reflects the year 2000. For YEAR(4), the value 0000 reflects the year zero. This only applies to numeric zero. String zero always reflects the year 2000.\n\nExamples\n--------\n\nCREATE TABLE y(y YEAR);\n\nINSERT INTO y VALUES (1990),('2012');\n\nSELECT * FROM y;\n+------+\n| y    |\n+------+\n| 1990 |\n| 2012 |\n+------+\n\nURL: https://mariadb.com/docs/server/reference/data-types/date-and-time-data-types/year-data-type