On this page

    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

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