The Oracle trunc() function throws away any offset in its argument, so queries like:

select truncate(offset datetime 1974-10-03 12:30-12:00, day)

return the wrong result.

The query above works correctly on all the other databases we test.