Skip to content

Latest commit

 

History

History
29 lines (22 loc) · 520 Bytes

File metadata and controls

29 lines (22 loc) · 520 Bytes
description
Returns the hexadecimal encoding of an expression.

HEX

Syntax

HEX(expression any primitive) → varchar

  • expression: The expression to encode.

Examples

{% code title="HEX example" %}

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

{% endcode %}

{% code title="HEX example" %}

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

{% endcode %}