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