|
hextobigint()
The
Datatype Conversion Function
hextobigint()
returns the number for a platform specific hexadecimal value.
The function hextobigint is available in
ASE®
starting with version 15.0.
Syntax of the Datatype Conversion Function hextobigint()
hextobigint( hexadecimal_string )
The parameter of the Datatype Conversion Function hextobigint()
hexadecimal_string
The parameter "hexadecimal_string" is a placeholder for its platform dependent hexadecimal equivalent of an integer number. The parameter can be used with the optional prefix "0x".
The return value is the corresponding integer number.
Example for the Datatype Conversion Function hextobigint()
select hextobigint("8000000000000000")
go
-----
-9223372036854775808
or
select hextobigint("0x8000000000000000")
go
-----
-9223372036854775808
See also:
ASE T-SQL - Aggregate Functions,
biginttohex(),
bintostr(),
cast(),
convert(),
Datatype Conversion Functions,
explicit conversion,
hextoint(),
implicit conversions,
inttohex().
|
