UTC date in Salesforce automatically modified to local time zone

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Post Reply
ruben.devoogdt
Posts: 1
Joined: Fri 31 Jul 2015 14:54

UTC date in Salesforce automatically modified to local time zone

Post by ruben.devoogdt » Fri 31 Jul 2015 14:56

Hi,

I am building an Integration between Salesforce and a SQL Server Database with SSIS.
In Salesforce dates are stored in UTC (GMT)
When I fetch records from Salesforce and insert them into a database table, the UTC date is converted to our local timezone (in our case GMT +2

We need the UTC date and not the local time when we fetch records from Salesforce. e.g. The field "SystemModstamp" in the database table should always be exactly the same as the one in Salesforce.

Is there a workaround for this problem?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: UTC date in Salesforce automatically modified to local time zone

Post by Shalex » Fri 31 Jul 2015 15:25

We have answered you by email.

Post Reply