TO_HEX¶

Converts an integer to a hexadecimal representation.

Syntax¶

TO_HEX( expr ) --> TEXT

Arguments¶

Parameter	Description
`expr`	An integer expression

Returns¶

Representation of the hexadecimal number of type TEXT.

Examples¶

For these examples, consider the following table and contents:

CREATE TABLE cool_numbers(number BIGINT NOT NULL);

INSERT INTO cool_numbers VALUES (42), (3735928559), (666), (3135097598), (3221229823);

Convert numbers to hexadecimal¶

master=> SELECT TO_HEX(number) FROM cool_numbers;
to_hex
------------------
0x000000000000002a
0x00000000deadbeef
0x000000000000029a
0x00000000baddcafe
0x00000000c00010ff