Re: [h2] hex

[mche...@gmail.com]

no, i have a column which is integer, I want to display it as hex. thanks

On Tuesday 16 January 2024 at 21:38:20 UTC+8 Andreas Reichel wrote:

> On Tue, 2024-01-16 at 05:24 -0800, mche...@gmail.com wrote:
>
> Hi
>possible to add a function to convert dec to hex for display?
>
> select hex(col) from table
>
> thanks
> Peter
>
> -- 
> You received this message because you are subscribed to the Google Groups 
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to h2-database...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/h2-database/079089e4-82f9-4828-9087-b61678e845ean%40googlegroups.com
>  
> 
> .
>
>
>
> this one: https://www.h2database.com/html/functions.html#hextoraw ?
>
> cheers
> Andreas
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/7079834b-4f26-4cb1-833e-e77fbd9ff1e9n%40googlegroups.com.

Re: [h2] hex

[Andreas Reichel]

On Tue, 2024-01-16 at 05:24 -0800, mche...@gmail.com wrote:
> Hi
>    possible to add a function to convert dec to hex for display?
> 
> select hex(col) from table
> 
> thanks
> Peter
> -- 
> You received this message because you are subscribed to the Google
> Groups "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it,
> send an email to h2-database+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/h2-database/079089e4-82f9-4828-9087-b61678e845ean%40googlegroups.com
> .


this one: https://www.h2database.com/html/functions.html#hextoraw ?

cheers
Andreas

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/f37581f6792dbae0428740efea9527b0356fe747.camel%40manticore-projects.com.

[h2] hex

[mche...@gmail.com]

Hi
   possible to add a function to convert dec to hex for display?

select hex(col) from table

thanks
Peter

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/079089e4-82f9-4828-9087-b61678e845ean%40googlegroups.com.