Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: Databricks SQL
Databricks Runtime
Converts expr
to hexadecimal.
Syntax
hex(expr)
Arguments
expr
: A BIGINT, BINARY, or STRING expression.
Returns
A STRING.
The function returns the hexadecimal representation of the argument.
Examples
> SELECT hex(17);
11
> SELECT hex('Spark SQL');
537061726B2053514C