How to resolve Ingres date to/from Oracle or SqlServer dates that have values that differ by a number of hours?
When dates are replicated between Ingres date and Oracle date or SQL Server date and the date values are a number of hours off this is most likely caused by an incorrect setting of the TZ (timezone) variable in the HVR process environment.
This can be fixed by adding action Environment with: Name TZ and Value TIMEZONENAME
Where TIMEZONENAME should be replaced with the name of the time zone required (e.g. GMT or Europe/Amsterdam).
Both replication jobs and refresh and compare are affected by this.