YEAR : YEAR : Data Types MySQL TUTORIALS


MySQL TUTORIALS » Data Types » YEAR »

 

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.




Leave a Comment / Note


 
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

MySQL TUTORIALS

 Navioo Data Types
» YEAR