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