Mega Code Archive

 

Categories / MySQL Tutorial / Data Types

 

YEAR

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.