HEX

Returns the hexadecimal encoding of an expression.

Syntax

HEX(expression any primitive) → varchar

• expression: The expression to encode.

Examples

HEX example

SELECT HEX('Spice')
-- EXPR$0
-- 4472656D696F

HEX example

SELECT HEX(2023)
-- EXPR$0
-- 7E7