This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.
MD5_NUMBER_UPPER64
Represent the upper 64 bits of the MD5 hash value of the input string as BIGINT.
Syntax
MD5_NUMBER_UPPER64(<expression>)
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:
SELECT
MD5_NUMBER_UPPER64('esimpson') AS username;
Returns: -4,517,210,933,321,929,797