TO_HEX

Returns a hexadecimal string for the given binary value.

Syntax

TO_HEX(in binary) → string

• in: A binary value.

Examples

TO_HEX example

SELECT to_hex(binary_string('hello'))
-- 68656C6C6F