Data Type Conversion

MatrixOne supports conversion between different data types. The following table lists the data type conversion support:

Convertible*: Use the cast function to perform explicit conversion. Cast*: Do not use the cast function, implicit conversion, that is, cast.

| Source Data Type | Target Data Type |Explanatory Conversion |Captive Conversion | | ------------------------------------------------------------------------------------------------------------------------------- | BOOLEAN | INTEGER | ❌ | ❌ | | | DECIMAL | ❌ | ❌ | | | VARCHAR | ✔ | ✔ | | DATE | TIMESTAMP | ✔ | ✔ | | | DATETIME | ✔ | ✔ | | | VARCHAR | ✔ | ✔ | | DATETIME | TIMESTAMP | ✔ | ✔ | | | DATE | ✔ | ✔ | | | VARCHAR | ✔ | ✔ | | FLOAT(Floating-point number) | INTEGER | ❌ | ❌ | | | DECIMAL | ✔ | ✔ | | | VARCHAR | ✔ | ✔ | | INTEGER | BOOLEAN | ❌ | ❌ | | | FLOAT | ✔️ | ✔ | | | TIMESTAMP | ✔ | ✔ | | | VARCHAR | ✔ | ✔ | | | DECIMAL | ✔ | ✔ | | TIMESTAMP | DATE | ✔ | ✔ | | | DATETIME | ✔ | ✔ | | | VARCHAR | ✔ | ✔ | | VARCHAR | BOOLEAN | ✔ | ✔ | | | DATE | ✔ | ✔ | | | FLOAT | ✔ | ✔ | | | INTEGER | ✔ | ✔ | | | DECIMAL | ✔ | ✔ | | | TIMESTAMP | ✔ | ✔ | | | DATETIME | ✔ | ✔ |