show hex value

[mche...@gmail.com]

hi

   possible to show show hex value from select?

thanks

Peter

[Evgenij Ryazanov]

Hi!

H2 Console already displays values of binary strings in hexadecimal format, if you need a similar feature in other tool you should ask its developers instead.

There is also a RAWTOHEX function, you can use it to convert a binary string to a character string with hexadecimal representation.

[mche...@gmail.com]

hi , possible to show an integer in hex format?

[Andreas Reichel]

Greetings.

On Sat, 2023-01-21 at 09:21 -0800, mche...@gmail.com wrote:

hi , possible to show an integer in hex format?

As far as I understand you can define your own Functions in H2, using Java language.

This should do the trick.

Cheers

Andreas

[Evgenij Ryazanov]

Hello!

There is a RAWTOHEX function, you can convert this integer number to a BINARY(4) data type and pass the result to this function:

SELECT RAWTOHEX(CAST(1234567890 AS BINARY(4)));

[mche...@gmail.com]

thank you sir