convert
Convert an expression to the specified data type.
Syntax
convert(<expr>, <dataType>)
| Parameter | Type | Description |
|---|---|---|
| expr | any | An expression which needs to be converted. |
| dataType | Text | An enumeration that includes: INT, FLOAT, STRING, BOOL, TIMESTAMP. |
Return values
Depends on input arguments.
Usage
Converts order number from string to integer for numeric operations.
convert(orders.order_number, INT)