parse_hex¶

Description¶

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

int64

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

parse_hex(hexstr)

Argument	Type	Optional	Repeatable	Restrictions
hexstr	string	no	no	none

make_col hexid:parse_hex(hexid)

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

parsehex (deprecated)