sha256()

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

Arguments & returns

2 overloads

Scalar

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

Scalar

Returns a VARCHAR with the SHA-256 hash of the value

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

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

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT sha256('🦆');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

HASH_SHA256(x)

In DuckDB

SHA256(x)

Used in larger rewrites 2

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

SHA256(x)

In DuckDB

UNHEX(SHA256(x))

SELECT SHA256(x)

In DuckDB

SELECT UNHEX(SHA256(x))