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

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;

username Decimal(38, 0)
13929533140387621819

Rows: 1Execution time: 4.57ms