Link Search Menu Expand Document

MD5_NUMBER_UPPER64

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

Syntax

MD5_NUMBER_UPPER64(<string>)
Parameter Description
<string> The string to calculate the MD5 on and represent as BIGINT

Example

SELECT
	MD5_NUMBER_UPPER64('test') AS res;

Returns: 688887797400064883