SHA1

Syntax

SHA1( value )

Description

Returns the SHA-1 hash of value as a hexadecimal string.

Argument types:

  • valueString

Return type: String

Example

SHA1("DataLens") = "F4EA6F8285E57FC18D8CA03672703B52C302231A"

Data source support

ClickHouse 21.8, MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, Trino, YDB.