TO_HEX

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Converts data to its equivalent hexadecimal representation.

  • <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.

Returns '7fffffff'.