String functions
MD5_NUMBER_UPPER64
Reference material for MD5_NUMBER_UPPER64 function
Represent the upper 64 bits of the MD5 hash value of the input string as BIGINT
.
Syntax
Parameters
Parameter | Description | Supported input type |
---|---|---|
<expression> | The string to calculate the MD5 hash value on and represent as BIGINT | TEXT |
Return Type
BIGINT
Example
The following example represents the username esimpson
as a BIGINT
:
Returns: -4,517,210,933,321,929,797