Comment on page
Type Casts
Expression | Example | Description |
CAST(expr AS type ) | CAST(1.25 AS FLOAT) | Converts an expression to another data type. For conversions to a TEXT type, use TRY_CAST. |
TRY_CAST(text_expr AS type ) | CAST('1.25' AS FLOAT) | Converts a text to a non-text type, returning null if the conversion could not be successfully performed. |
ENCODE_TEXT(none_encoded_str ) | ENCODE_TEXT(long_str) | Converts a none-encoded text type to a dictionary-encoded text type. |
The following table shows cast type conversion support.
FROM/TO: | TINYINT | SMALLINT | INTEGER | BIGINT | FLOAT | DOUBLE | DECIMAL | TEXT | BOOLEAN | DATE | TIME | TIMESTAMP |
TINYINT | - | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No | n/a |
SMALLINT | Yes | - | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No | n/a |
INTEGER | Yes | Yes | - | Yes | Yes | Yes | Yes | Yes | Yes | No | No | No |
BIGINT | Yes | Yes | Yes | - | Yes | Yes | Yes | Yes | No | No | No | No |
FLOAT | Yes | Yes | Yes | Yes | - | Yes | No | Yes | No | No | No | No |
DOUBLE | Yes | Yes | Yes | Yes | Yes | - | No | Yes | No | No | No | n/a |
DECIMAL | Yes | Yes | Yes | Yes | Yes | Yes | - | Yes | No | No | No | n/a |
TEXT | Yes (Use TRY_CAST) | Yes (Use TRY_CAST) | Yes (Use TRY_CAST) | Yes (Use TRY_CAST) | Yes (Use TRY_CAST) | Yes (Use TRY_CAST) | Yes (Use TRY_CAST) | - | Yes (Use TRY_CAST) | Yes (Use TRY_CAST) | Yes (Use TRY_CAST) | Yes (Use TRY_CAST) |
BOOLEAN | No | No | Yes | No | No | No | No | Yes | - | n/a | n/a | n/a |
DATE | No | No | No | No | No | No | No | Yes | n/a | - | No | Yes |
TIME | No | No | No | No | No | No | No | Yes | n/a | No | - | n/a |
TIMESTAMP | No | No | No | No | No | No | No | Yes | n/a | Yes | No | - |
Last modified 1yr ago