CAST
Casts the input expression to the specified type.
Syntax
Example
Transformation job example
SQL
In the the following example, the nettotal column, which is a double, is converted to a string to enable it to be concatenated with the dollar symbol:
Query result
orderid | nettotal | orderdate |
---|---|---|
cU1QEyPKKc | $2018.37 | 2023-07-24T15:54:00Z |
6eI2KeIc2A | $1842.35 | 2023-07-24T15:54:00Z |
yRQUXyRPTP | $1144.7 | 2023-07-24T15:54:00Z |
Last updated