Duration and Time field values use the UTC timezone in the ODBC Driver version 1.0.10

Automatic changes in ODBC 1.0.10

Starting with the 1.0.10 version of the ODBC Driver, duration and timer field values are displayed using the UTC timezone. Prior to 1.0.10, duration and timer field values were displayed using the local time of the computer the ODBC Driver is installed on.

This change affects only queries on the raw field values and does not affect queries on display values.

Legacy support

The ODBC Driver property LegacyDurationTimeZone was added to provide support for legacy configurations. This property is false by default.

To display duration and time fields using the display value instead of the UTC value, set this property to true. This property should be used only to preserve compatibility with legacy configurations.

Querying display values

You can query the display value of a duration or timer field. To query the display value, add dv_ to the start of the field name, such as dv_delivery_time to query the display value of the Delivery time [delivery_time] field.




Article Information

Last Updated:2019-08-02 21:25:24