FROM_HEX function - Amazon Redshift
SyntaxArgumentsReturn typeExamples

Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the blog post .

FROM_HEX function

FROM_HEX converts a hexadecimal to a binary value.

Syntax

FROM_HEX(hex_string)

Arguments

hex_string

Hexadecimal string of data type VARCHAR or TEXT to be converted. The format must be a literal value.

Return type

VARBYTE

Examples

To convert the hexadecimal representation of '6162' to a binary value, use the following example. The result is automatically shown as the hexadecimal representation of the binary value.

SELECT FROM_HEX('6162');
               
+----------+
| from_hex |
+----------+
|     6162 |
+----------+