TO_HEX
The TO_HEX function converts data from the binary data type to a character data type in which the character is represented in hexadecimal format.
Syntax
TO_HEX (binary_expression)
Remarks
• The argument binary_expression evaluates to the integer to be converted to a hexadecimal value.
• Returns a VARCHAR representing the hexadecimal equivalent of a number.
Example
SELECT TO_HEX (‘Binary’::binary(2));
This returns:
8046