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