Edit on GitHub
How to Fix Date Value Replication Issues Between Ingres, Oracle, and SQL Serverlink
Introductionlink
How to resolve the date replication issue between Ingres, Oracle, and SQL Server where the date values differ by a few hours?
Overviewlink
This issue can be caused by the differences in the timezone settings of the source and target databases.
Resolutionlink
This can be fixed by adding action Environment with the parameters /Name=TZ /Value="TIMEZONENAME", where "TIMEZONENAME" should be replaced with the required time zone (e.g. GMT or Europe/Amsterdam).
Both replication jobs and refresh and compare are affected by this.