ODBC date and time values

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 field types.