sha1()

Returns a VARCHAR with the SHA-1 hash of the blob.

Arguments & returns

2 overloads

Scalar

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

Scalar

Returns a VARCHAR with the SHA-1 hash of the value.

Overload link	`value`	Returns
#02	`VARCHAR`	`VARCHAR`

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

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT sha1('🦆');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Used in larger rewrites 1

These examples use sha1 as one part of a larger SQL translation.

SHA1(x)

In DuckDB

UNHEX(SHA1(x))