parse_hex(hexstr: string) -> int64

Parses a string encoded hex number and returns an int64.

Values should be strings, not start with 0x, and only include valid hex characters. NULL will be returned in case of an error

Domain

This is a scalar function (calculates a single output value for a single input row).

Examples

Will change the hexid column from a hex string to an int64 value.