This topic describes the date and time data types supported by PolarDB-X 1.0.
PolarDB-X 1.0 supports the following date and time data types:
- DATE
- DATETIME
- TIMESTAMP
- TIME
- YEAR
Note The value range for the TIME data type in MySQL is different from that in PolarDB-X 1.0. In PolarDB-X 1.0, the value range for the TIME data type is '00:00:00' to '23:59:59'.
For more information, see Date and time data types in the Reference Manual of MySQL.