How the ODBC driver expresses dates and times.
The instance and the machine that the ODBC driver is installed on may use two different
time zones. Date and time values returned by the ODBC driver are in the local time zone of
the application using the driver, not the ServiceNow instance time zone.
Ensure that you query in accurate time zones for both the instance and the machine that
hosts the ODBC driver. GlideRecord performs filtering based on the instance time zone and
the ODBC client is filtered based on the Windows time zone.
For example, if an instance is in Central Standard Time (CST) and the ODBC driver is
installed on a machine that is in Pacific Standard Time (PST), and an incident is created on
the instance at 2014-05-20 10:00:00, the time that the incident was created displays
in the UI as 10:00:00 for users in both time zones. However, in order to successfully
query this incident by creation date and time, a user on the machine in PST must query
2014-05-20 08:00:00 instead of 2014-05-20 10:00:00.
Duration and timer type fields are returned using the UTC timezone, starting with the ODBC
version 1.0.10. See KB0583982 for details about this change. See ODBC display values for more information about display values for these