# **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 | ✔ | ✔ |