Link Search Menu Expand Document

MD5_NUMBER_LOWER64

Represent the lower 64 bits of the MD5 hash value of the input string as BIGINT.

Syntax

MD5_NUMBER_LOWER64(<string>)
Parameter Description
<string> The string to calculate the MD5 hash value on and represent as BIGINT.

Example

SELECT
	MD5_NUMBER_LOWER64('test') AS res;

Returns: 14618207765679027446