Returns the bigint value equivalent of a hexadecimal string
hextobigint(hexadecimal_string)
is the hexadecimal value to be converted to an big integer; must be a character-type column, variable name, or a valid hexadecimal string, with or without a “0x” prefix, enclosed in quotes.
The following example converts the hexadecimal string 0x7fffffffffffffff to a big integer.
1> select hextobigint("0x7fffffffffffffff")
2> go
--------------------
9223372036854775807
hextobigint, a datatype conversion function, returns the platform-independent integer equivalent of a hexadecimal string.
Use the hextobigint function for platform-independent conversions of hexadecimal data to integers. hextobigint accepts a valid hexadecimal string, with or without a “0x” prefix, enclosed in quotes, or the name of a character-type column or variable.
hextobigint returns the bigint equivalent of the hexadecimal string. The function always returns the same bigint equivalent for a given hexadecimal string, regardless of the platform on which it is executed.
Functions biginttohex, convert, inttohex, hextoint
