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.
There is no workaround for this Known Error at this time.
Related Problem: PRB584916