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))