HEX_TO_DECIMAL
Converts a hexadecimal string value to the corresponding signed 64-bit integer.
Syntax
Arguments
Name | Type | Description | Default Value |
---|---|---|---|
value | string | The hexadecimal string value to convert |
Returns
Returns a bigint
value.
Examples
value | Output |
---|---|
'###' | null |
'ff' | 255 |
'0xff' | 255 |
Transformation job example
SQL
Query result
value | Output |
---|---|
'###' | null |
Last updated