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

Return type

int64

Domain

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

Categories

Usage

parse_hex( hexstr )

Argument

Type

Required

Multiple

hexstr

string

Required

Only one

Examples

make_col hexid:parse_hex(hexid)

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

Aliases

parsehex (deprecated)