According to the SQL Standard, result of subtraction of one datetime value
from another is an interval, but Oracle violates the Standard and returns a
DATE JULIAN for (DATE - DATE) and NUMBER for (TIMESTAMP - TIMESTAMP) for
historic reasons. H2 does not provide compatibility on that level,
Hello.
I think it can be caused only by invalid SQL that was used with the old
version of H2 as a workaround over its missing features, and that
workaround doesn't work any more; or by some other invalid SQL expression
that somehow worked in the old version.
You need to show us your query,