CAST

Categories: Conversion

CAST

Converts a value of one data type to another data type. This function behaves similarly to the TO_<data_type> (i.e. TO_TIMESTAMP) functions.

Syntax

CAST(expression Any type, data_type Any type) → Type specified as data_type parameter

• expression: The expression that you want to convert
• data_type: The name of the data type that you want to convert the input expression to.

Examples

{{< codeheader "CAST example" >}}

SELECT CAST(3.14150 AS INTEGER)
-- 3

{{< codeheader "CAST example" >}}

SELECT CAST(.167 AS INTEGER)
-- 0

{{< codeheader "CAST example" >}}

SELECT CAST('2021-04-03' AS DATE)
-- 2021-04-03