ODBC Driver for Salesforce

Build 24.0.9175

Working with Timezones

Specifying Timezones

The Salesforce API expects the timezone to be specified when processing queries related to time fields.

By default, time columns are interpreted as being in GMT. For example:

SELECT Id FROM BusinessHours WHERE SundayStartTime = '18:00:00'

To specify a UTC offset time, alter the filter like this:

SELECT Id FROM BusinessHours WHERE SundayStartTime = '18:00:00+03:00'

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175