Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

MD5 Function

Uses the MD5 cryptographic hash function to convert a variable-length string into a 32-character string that is a text representation of the hexadecimal value of a 128-bit checksum.

Syntax

Copy
MD5(string)

Arguments

string

A variable-length string.

Return Type

The MD5 function returns a 32-character string that is a text representation of the hexadecimal value of a 128-bit checksum.

Examples

The following example shows the 128-bit value for the string 'Amazon Redshift':

Copy
select md5('Amazon Redshift'); md5 ---------------------------------- f7415e33f972c03abd4f3fed36748f7a (1 row)