This looks like a limitation of Oracle’s native TRUNC(date) function, the relative docs state:
The value returned is always of data type DATE, even if you specify a different datetime data type for date
causing loss of the timezone information. I’m not sure but how we might be able to get around this, maybe always emulating and using to_timestamp_tz instead of to_date (which has the same problem)? |