biginttohex

Returns the platform-independent 8 byte hexadecimal equivalent of the specified integer.

Syntax

biginttohex (integer_expression)

Parameters

integer_expression – is the integer value to be converted to a hexadecimal string.

Examples

Example 1 – Converts the big integer -9223372036854775808 to a hexadecimal string:

1> select biginttohex(-9223372036854775808)
2> go
----------------
8000000000000000

Usage

biginttohex, a datatype conversion function, returns the platform-independent hexadecimal equivalent of an integer, without a “0x” prefix.
Use the biginttohex function for platform-independent conversions of integers to hexadecimal strings. biginttohex accepts any expression that evaluates to a bigint. It always returns the same hexadecimal equivalent for a given expression, regardless of the platform on which it is executed.

Permissions

Any user can execute biginttohex.

Parent topic: Transact-SQL Functions

Related reference

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com