SHA2 function
The SHA2 function uses the SHA2 cryptographic hash function to convert a variable-length string into a character string. The character string is a text representation of the hexadecimal value of the checksum with the specified number of bits.
Syntax
SHA2(string, bits)
Arguments
- string
-
A variable-length string.
- integer
-
The number of bits in the hash functions. Valid values are 0 (same as 256), 224, 256, 384, and 512.
Return type
The SHA2 function returns a character string that is a text representation of the hexadecimal value of the checksum or an empty string if the number of bits is invalid.
Example
The following example returns the 256-bit value for the word 'Amazon Redshift':
select sha2('Amazon Redshift', 256);