Introduction

Find out how to resolve Ingres date to/from Oracle or SqlServer dates that have values that differ by a number of hours.

Overview

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 Local Data Processing process environment.

Resolution

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.