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.

Calculates the MD5 hash of string, returning the result as a string in hexadecimal.

​
Syntax

MD5(<expression>)

​
Parameters

ParameterDescriptionSupported input types
<expression>The string to hash.TEXT

​
Return Types

  • Returns TEXT with string input
  • Returns NULL if input is NULL

​
Example

The following example returns the username esimpson in hexadecimal: 
SELECT
	MD5('esimpson') AS username;
Returns: c14fa496dfd5ebbb08aaca16a7c2781b