PostgreSQL TO HEX

Postgresql to_hex

Converts a number to a hexadecimal representation.

Syntax to_hex

to_hex(number)

Example 1

test2=# SELECT to_hex(4900);
 to_hex 
--------
 1324
(1 row)

Related Links

• Postgresql String Functions
• Learning PostgreSQL
• Tutorial Home

---

• string concate
• bit_length
• char_length
• character_length
• lower
• octet_length
• overlay
• position
• substring
• trim
• upper
• ascii
• btrim

• chr
• concat
• concat_ws
• convert
• convert_from
• convert_to
• decode
• encode
• format
• initcap
• left
• length

• lpad
• ltrim
• md5
• pg_client_encoding
• quote_ident
• quote_literal

• quote_nullable
• regexp_matches
• regexp_replace
• regexp_split_to_array
• regexp_split_to_table

• repeat
• replace
• reverse
• right
• rpad
• rtrim
• split_part
• strpos
• substr
• to_ascii
• to_hex
• translate