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

Visual Basic
C#

'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 QuickBooks Online. In many cases QuickBooks Online may display different values than set or returned via dotConnect for QuickBooks Online because of different time zone settings in your SqlShimConnection and in QuickBooks Online. For example, if you set UtcDates to true, and QuickBooks Online 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 QuickBooks Online as a UTC value. When displaying this value in the QuickBooks Online interface, QuickBooks Online 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 QuickBooks Online is configured to display datetime values in your local time, the date values returned via dotConnect for QuickBooks Online may differ from the values, displayed by QuickBooks Online. This happens because in this example QuickBooks Online convertsthe values to your local time when displaying them, and dotConnect for QuickBooks Online doesn't.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

SqlShimConnectionStringBuilder Class
SqlShimConnectionStringBuilder Members

Send Feedback