H2 Oracle mode - subtraction of two dates. Integer in H2, real in Oracle

Vote count:

0

We use H2 from JUnit for testing an Oracle based application.

The application does select (date1 - date2) diff from ...

That gives a real number in Oracle (e.g. 2.75 days), while it gives an an integer in h2 in Oracle mode.

I know I can use datediff in H2, but I have not found a function that gives the same result as in Oracle, and that can also be used in Oracle.

Is there a plan for supporting the Oracle difference between two dates?

asked 1 min ago

SvRekaa

1

H2 Oracle mode - subtraction of two dates. Integer in H2, real in Oracle