Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

HEX

The HEX() function returns the hexadecimal representation of numeric, string, or binary data.

Syntax

HEX (expression)

Arguments

  • expression: any valid expression. This can be a column name, literal, or the return value of another function.

Return Type

Upper-case hexadecimal string.

Remarks

  • Numeric Arguments: When the argument to HEX is numeric (e.g. integer, real, or decimal), the HEX function operates on the binary representation of the value as follows.

    • The numeric value is treated as an unsigned BIGINT and the result is the HEX of the unsigned BIGINT value.

    • UNHEX is not the inverse of HEX for numeric values.

      • For example, UNHEX(HEX(1234)) != 1234.

  • String, BLOB, and Vector Arguments: When the argument to HEX is a string, BLOB, or vector, each byte of the string, BLOB, or vector is converted to two hexadecimal digits.

    • For example, HEX('[1,2,3]':>VECTOR(3,F32)) = 0000803F0000004000004040.

      • 0000803F is the hexadecimal representation of the floating point representation of 1 (the first element in the vector).

    • HEX is the inverse of UNHEX for strings, BLOBs, and vectors.

      • For example, UNHEX(HEX('1234')) = '1234'.

Examples

SELECT HEX(1234);
+-----------+
| HEX(1234) |
+-----------+
| 4D2       |
+-----------+
SELECT HEX('1234');
+-------------+
| HEX('1234') |
+-------------+
| 31323334    |
+-------------+
SELECT HEX('ohai');
+-------------+
| HEX('ohai') |
+-------------+
| 6F686169    |
+-------------+
SELECT HEX('[1,2,3]':>VECTOR(3,F32));
+-------------------------------+
| HEX('[1,2,3]':>VECTOR(3,F32)) |
+-------------------------------+
| 0000803F0000004000004040      |
+-------------------------------+

Last modified:

Was this article helpful?