Ingres date to/from Oracle/SQL Server dates have values that differ by a number of hours off

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #10976
    ggoodrich
    Keymaster

    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.

Viewing 1 post (of 1 total)
  • The forum ‘Expert Notes’ is closed to new topics and replies.

© 2020 HVR

Test drive Contact us