Skip to main content
Version: 0.0.1

HEX

Categories: Conversion, String, Binary

HEX

Returns the hexadecimal encoding of an expression.

Syntax​

HEX(expression any primitive) → varchar​

  • expression: The expression to encode.

Examples

{{< codeheader "HEX example" >}}

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

{{< codeheader "HEX example" >}}

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