SQL: Convert integer into formatted hex string

Question

In PostgreSQL, let's say I have the following table:

+-------+---------+
|       | someVal |
| myInt |         |
+-------+---------+
| 123   | a       |
+-------+---------+
| 456   | b       |
+-------+---------+
| 789   | c       |
+-------+---------+

I want to convert the myInt column into a formatted string that contains the hex representation of the integer in it and rename the column. So it would look something like the following:

+----------+---------+
|          | someVal |
| myHex    |         |
+----------+---------+
| hex: 7B  | a       |
+----------+---------+
| hex: 1C8 | b       |
+----------+---------+
| hex: 315 | c       |
+----------+---------+

What would the query look like to convert the integer?

Please show us what you tried and where you got stuck.

Dale K
– Dale K

2020-05-08 03:00:26 +00:00
Commented May 8, 2020 at 3:00 — Dale K
– Dale K, Commented May 8, 2020 at 3:00

zealous · Accepted Answer · 2020-05-08 03:10:06Z

2

Try the following in PostgreSQL.

select
   concat('hex: ', cast(to_hex(ms) as text)) as myHex,
   someVal
from yourTable

edited May 8, 2020 at 3:10

answered May 8, 2020 at 3:02

zealous

7,5434 gold badges20 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

nao Over a year ago

I want it to be a string with that hex interpolated inside of it.

Collectives™ on Stack Overflow

SQL: Convert integer into formatted hex string

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related