to_char function hexadecimal formats error in Postgresql

Question

I want to use to_char function in Postgresql but take an error when execute the script.

Oracle version is ok;

to_char('7374961057827412212','XXXXXXXXXXXXXXXXXXXX') 

result : 66592002042458F4

But I could not find Postgresql version and take an error like this;

ERROR:  function to_char(text, unknown) does not exist

Laurenz Albe · Accepted Answer · 2021-10-06 15:09:04Z

1

If you look at the table of formatting codes for numbers, you will see that X is not supported, and indeed there is no way to get hexadecimal output with to_char.

But you can use to_hex:

SELECT to_hex(7374961057827412212);

      to_hex      
══════════════════
 66592002042458f4
(1 row)

The error message you see is because you entered the first argument in single quotes, so it is a string (data type text), but there is no to_char function to format strings as strings (they are already strings).

answered Oct 6, 2021 at 15:09

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

Collectives™ on Stack Overflow

to_char function hexadecimal formats error in Postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related