How to Fix Date Value Replication Issues Between Ingres, Oracle, and SQL Server
Introduction
How to resolve the date replication issue between Ingres, Oracle, and SQL Server where the date values differ by a few hours?
Overview
This issue can be caused by the differences in the timezone settings of the source and target databases.
Resolution
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.