2.10.2.6.6. Typecasts

The CAST function converts an expression of one type to an expression of a different type.

  • string_cast_function::= CAST(scalar_expression AS STRING)

  • arithmetic_cast_function::= CAST(string_expression AS {INTEGER | LONG | FLOAT | DOUBLE})

Examples

UPDATE Invoice AS inv SET inv.description = CONCAT('Price ', CAST(inv.price AS STRING))