dotConnect for Salesforce Documentation
Devart.Data Namespace / SqlShimConnectionStringBuilder Class / UtcDates Property

In This Topic
    UtcDates Property
    In This Topic
    Indicates whether all the datetime values retrieved from the data source are returned as UTC values or converted to local time, and whether date values, specified on the application side (for example, in SQL statements) are considered UTC or local.
    Syntax
    'Declaration
     
    Public Property UtcDates As Boolean
    public bool UtcDates {get; set;}

    Property Value

    true, if the datetime values retrieved from the data source are returned as UTC values, and the date values specified on the application side should be considered UTC when sending them to the data source; otherwise, false. Default value is false.
    Remarks

    Please note that it is important to consider the value of this parameter in your connections and the corresponding settings of the Salesforce.com or Database.com. In many cases Salesforce.com or Database.com may display different values than set or returned via dotConnect for Salesforce because of different time zone settings in your SqlShimConnection and in Salesforce.com or Database.com. For example, if you set UtcDates to true, and Salesforce.com or Database.com is configured to display datetime values in your local time, when you specify a datetime value in an INSERT or UPDATE statement, it is treated and sent to Salesforce.com or Database.com as a UTC value. When displaying this value in the Salesforce.com or Database.com interface, Salesforce.com or Database.com converts it to your local time, and thus displays a different value than the one that was specified in the INSERT or UPDATE statement.

    The same is correct when selecting data. If UtcDates is set to true, and Salesforce.com or Database.com is configured to display datetime values in your local time, the date values returned via dotConnect for Salesforce may differ from the values, displayed by Salesforce.com or Database.com. This happens because in this example Salesforce.com or Database.com convertsthe values to your local time when displaying them, and dotConnect for Salesforce doesn't.

    See Also