MD5

Syntax

MD5( value )

Description

Returns the MD5 hash of value as a hexadecimal string.

Argument types:

  • value — String

Return type: String

Example

MD5("DataLens") = "C1FD5D9E4189FB89C1021A72F7E06C00"

Data source support

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

Previous
INTHASH64
Next
MURMURHASH2_64