Table Output Step ignores metadata timezone.
With version 5 time zones were introduced for the Date datatype.
This is a very important development for cloud enablement.
Yet some components are still ignoring this parameter.
Table Output is one of them, and probably is one of the most critical ones.
Attaching DDL and the demo workflow.
Please ensure that Spoon uses timezone different from the UTC/GMT.
Enforce if necessary by setting option in Spoon.bat:
As you can see the Date taken into account is correctly parsed as UTC
Yet TIMESTAMP value (and Oracle Value for Date, as it is converted into Timestamp) are
Which is incorrect, as the TIMESTAMP in Oracle is Time Zone agnostic.