(mysql.info.gz) YEAR
Info Catalog
(mysql.info.gz) TIME
(mysql.info.gz) Date and time types
(mysql.info.gz) Y2K issues
11.3.3 The `YEAR' Type
----------------------
The `YEAR' type is a one-byte type used for representing years.
MySQL retrieves and displays `YEAR' values in `YYYY' format. The range
is `1901' to `2155'.
You can specify `YEAR' values in a variety of formats:
* As a four-digit string in the range `'1901'' to `'2155''.
* As a four-digit number in the range `1901' to `2155'.
* As a two-digit string in the range `'00'' to `'99''. Values in the
ranges `'00'' to `'69'' and `'70'' to `'99'' are converted to
`YEAR' values in the ranges `2000' to `2069' and `1970' to `1999'.
* As a two-digit number in the range `1' to `99'. Values in the
ranges `1' to `69' and `70' to `99' are converted to `YEAR' values
in the ranges `2001' to `2069' and `1970' to `1999'. Note that
the range for two-digit numbers is slightly different from the
range for two-digit strings, because you cannot specify zero
directly as a number and have it be interpreted as `2000'. You
must specify it as a string `'0'' or `'00'' or it will be
interpreted as `0000'.
* As the result of a function that returns a value that is acceptable
in a `YEAR' context, such as `NOW()'.
Illegal `YEAR' values are converted to `0000'.
Info Catalog
(mysql.info.gz) TIME
(mysql.info.gz) Date and time types
(mysql.info.gz) Y2K issues
automatically generated byinfo2html