YEAR : YEAR « Data Types « MySQL Tutorial






YEAR records the year and occupies just 1 byte of data.

YEAR values can range from 1901 to 2155.

You can specify a year in either string or numeric notation.

YEAR values can be specified in either two- or four-digit form.

Two-digit years are converted to four digits.

Two-digit years in the range 1 to 69 (or '0' to '69') will be taken as years from 2001 through 2069.

Years in the range 70 to 99 will be interpreted as being in the range 1970 through 1999.









10.26.YEAR
10.26.1.YEAR
10.26.2.YEAR column type
10.26.3.Insert value to a YEAR type column
10.26.4.Two-digit year
10.26.5.Four-digit year
10.26.6.To determine how many years served