sha1()

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

Reference: DuckDB 2.0.0

Arguments & returns

2 overloads

sha1(blob)

Scalar
Overload link blob Returns
#01 BLOB VARCHAR

sha1(value)

Scalar

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

Overload link value Returns
#02 VARCHAR VARCHAR
sha1 example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.

More examples

sha1 example 2
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.

In other engines

Snowflakesha1()

Same function
Used in larger rewrites 1

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

BigQuerysha1()

SHA1(x)
In DuckDB
UNHEX(SHA1(x))

SQLGlot example ↗