All Products
Document Center

Data type precedence

Last Updated: Jun 18, 2021

ApsaraDB for OceanBase uses the data type precedence to specify the order in which data types are implicitly converted.

The following list provides the precedence from highest to lowest for converting data types in ApsaraDB for OceanBase.

  1. DATETIME and INTERVAL data types

  2. BINARY_DOUBLE data type
  3. BINARY_FLOAT data type
  4. NUMBER data type
  5. Character data types

  6. All the other built-in data types