754 views

Description

The behavior behind the ODBC driver is that it returns date/time stamps based on UTC. In this case, the ODBC driver is failing to offset UTC (for example, UTC+1) in consideration for daylight savings/summer time adjustment.

Steps to Reproduce

 

  • Set time zone of instance to Central US Time.
  • Create a Change record with start and end dates.
  • Query SQL for those times (should show in UTC/GMT).
  • Make sure machine with ODBC installed is in BST (London summer time) time zone.
  • Query the same times using the ODBC driver.
  • Notice that the ODBC driver time is out by 1 hour.

Workaround

There is no workaround for this Known Error at this time.

Related Problem: PRB584916

Seen In

Eureka Patch 7

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2015-04-07 14:31:40
Published:2014-01-27