question about to_char

[Gmail]

Hi,

I am using H2 2.1.214.

the following :

select to_char(2E+1,'9999D00') from dual;
------
|2E+1|
------

select to_char(.0000001+2E+1,'9999D00') from dual;

------------
|20.0000001|
------------

Should the first select not give 20.00 as result ?

Kind regards

Willy

[Evgenij Ryazanov]

Hello!

Yes, it's a bug. Implementation of this Oracle compatibility function doesn't handle DECFLOAT arguments properly, but you can cast them to a some other numeric types as a workaround.

TO_CHAR(CAST(2E+1 AS NUMERIC(6, 2)), '9999D00')

Approximate numeric literals (with exponent) have DECFLOAT data type in new versions of H2.