Skip to main content

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