hex scalar function

Example

Local

-- Display the raw bytes of the mainnet USDC address

SELECT hex('0xA0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'::ADDRESS) AS address_hex;

-- => [{"address_hex":"A0B86991C6218B36C1D19D4A2E9EB0CE3606EB48"}]

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.

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

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.

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.

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.