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	-