FROM_HEX function - Amazon Redshift

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 | +----------+