Skip to main content

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

CAST example
SELECT CAST(3.14150 AS INTEGER)
-- 3
CAST example
SELECT CAST(.167 AS INTEGER)
-- 0
CAST example
SELECT CAST('2021-04-03' AS DATE)
-- 2021-04-03