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