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.