Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt

Use this file to discover all available pages before exploring further.

Represent the lower 64 bits of the MD5 hash value of the input string as BIGINT.

​
Syntax

MD5_NUMBER_LOWER64(<expression>)

​
Parameters

ParameterDescriptionSupported input type
<expression>The string to calculate the MD5 hash value on and represent as BIGINTTEXT

​
Return Type

BIGINT

​
Example

The following example represents the username esimpson as a BIGINT: 
SELECT
	MD5_NUMBER_LOWER64('esimpson') AS username;
Returns: 624,533,696,996,866,075