to_hex scalar function

Example

Local

-- to_hex is the compatibility alias of hex

SELECT to_hex('0xa9059cbb'::BYTES4) AS selector_hex;

-- => [{"selector_hex":"A9059CBB"}]

Enable JavaScript to run this sample in the notebook. The SQL preview above is still available for reference.

Exact signatures with descriptions, requirements, inputs, returns, and examples.

to_hex(ADDRESS) #

Returns uppercase hexadecimal for the stored bytes of ADDRESS, BYTES4, BYTES32, or BYTES256.

Name	Type	Use
`value`	ADDRESS ADDRESS, BYTES4, BYTES32, or BYTES256 value encoded exactly as stored.	required positional

Name	Type
`hex`	VARCHAR

Uppercase hexadecimal text. Returns two uppercase hex characters per stored byte, without a 0x prefix. NULL returns NULL.

3 additional overloads

to_hex(BYTES4) #

Returns uppercase hexadecimal for the stored bytes of ADDRESS, BYTES4, BYTES32, or BYTES256.

Name	Type	Use
`value`	BYTES4 ADDRESS, BYTES4, BYTES32, or BYTES256 value encoded exactly as stored.	required positional

Name	Type
`hex`	VARCHAR

Uppercase hexadecimal text. Returns two uppercase hex characters per stored byte, without a 0x prefix. NULL returns NULL.

to_hex(BYTES32) #

Returns uppercase hexadecimal for the stored bytes of ADDRESS, BYTES4, BYTES32, or BYTES256.

Name	Type	Use
`value`	BYTES32 ADDRESS, BYTES4, BYTES32, or BYTES256 value encoded exactly as stored.	required positional

Name	Type
`hex`	VARCHAR

Uppercase hexadecimal text. Returns two uppercase hex characters per stored byte, without a 0x prefix. NULL returns NULL.

to_hex(BYTES256) #

Returns uppercase hexadecimal for the stored bytes of ADDRESS, BYTES4, BYTES32, or BYTES256.

Name	Type	Use
`value`	BYTES256 ADDRESS, BYTES4, BYTES32, or BYTES256 value encoded exactly as stored.	required positional

Name	Type
`hex`	VARCHAR

Uppercase hexadecimal text. Returns two uppercase hex characters per stored byte, without a 0x prefix. NULL returns NULL.