hex()

Converts blob to VARCHAR using hexadecimal encoding.

Arguments & returns

7 overloads

Scalar

Overload link	`blob`	Returns
#01	`BLOB`	`VARCHAR`

Scalar

Converts the string to hexadecimal representation.

Overload link	`string`	Returns
#02	`VARCHAR`	`VARCHAR`

Scalar

Converts the value to VARCHAR using hexadecimal representation.

SELECT hex('\xAA\xBB'::BLOB);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT hex('Hello');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT hex(42);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

UPPER(TO_HEX(x))

In DuckDB

HEX(x)