SQL · String functions

to_hex()

Formats an integer as hexadecimal. PostgreSQL.

sqlRunnable example sql course

Syntax

to_hex(integer)

Example

Open in the lab

SELECT printf('%x', 255) AS hex;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.