hex
function
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