TO_HEX

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Converts data to its equivalent hexadecimal representation.

1to_hex(<data>)

• <data>: The data to encode (int, bigint, or bytea).

Returns a text value containing the hexadecimal representation of the data.

• Output is lowercase hexadecimal without a ‘0x’ prefix.

Encode an integer to hexadecimal.

1SELECT to_hex(2147483647) AS result;

Returns '7fffffff'.

• String Types