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