Link Search Menu Expand Document

This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.

MD5

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

Syntax 

MD5(<expression>)

Parameters

Parameter Description Supported 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