TO_HEX

​

Syntax

​

Scalar

to_hex(value)

​

Arguments

​

Returns

• Type: STRING
• Possible values: Uppercase hex digits.
• NULL behavior: NULL input returns NULL.

​

Properties

​

Examples

​

Typical behavior

SELECT to_hex('A') AS "value";

​

Encode multibyte text

SELECT to_hex('é') AS encoded;

​

Limitations

• TO_HEX takes one STRING argument. Use HEX for integer or BINARY values. A second TO_HEX argument is not supported.