CAST

CAST

Syntax

    CAST(value, type)

To cast types to Number you can use one of three forms:

    SELECT CAST(a AS NUMBER), FORMAT(NUMBER,a), a::NUMBER 

See also: CONVERT, [:: - double colon](Double Colon)