topic Salesforce Date Conversion in Talend Studio

Salesforce Date Conversion

anut — Sat, 16 Nov 2024 09:38:12 GMT

We are using Talend Data Integration 6.1.1. Data source to one of the ETL is from Salesforce/TargetX.

In Salesforce, date field is seen as 2017-05-02T02:25:16.000Z but the same data using Talend's Salesforce Component, I see it as 2017-05-03T02:25:16.000Z .

As per my research so far, Salesforce is carrying all date/time values internally as GMT and then for display purposes, adjusts it to local time. GMT is 7 hours ahead of PDT. Talend doesn't seem to be handling the adjustment automatically in my case based on local server time.

Any suggestions on how to handle this ?

Thanks,

Re: Salesforce Date Conversion

TRF — Tue, 13 Jun 2017 22:25:12 GMT

Did you check the timezone for the user associated to the tSalesforceConnection?

Re: Salesforce Date Conversion

anut — Tue, 13 Jun 2017 22:33:30 GMT

User Timezone is PDT.

Thanks,

Re: Salesforce Date Conversion

Anonymous — Fri, 17 Nov 2017 15:17:23 GMT

Hello,

Have you found a solution with talend, i have the same problem with the timezone ?

Re: Salesforce Date Conversion

TRF — Sat, 18 Nov 2017 20:13:48 GMT

Hi,

From Salesforce, define the connected user timezone as GMT, read the datatime value, then convert the result to the desired TZ with the appropriate Java code.

To Salesfore, define the connected user timezone as GMT, convert the datetime from the original TZ to GMT with the appropriate Java code, then load the result to Salesforce.

Note:

Supported time zones for Salesforce are here and here for the Java method TimeZone.getTimeZone.

Re: Salesforce Date Conversion

Anonymous — Mon, 20 Nov 2017 13:44:47 GMT

Hi Twelve Stars,

Thanks but It's strange, i have a date 2017-10-27 in a file, i want to load it into salesforce object with talend, but finally i obtain 2017-10-26, my time zone on salesforce is GMT-0

Re: Salesforce Date Conversion

Anonymous — Mon, 20 Nov 2017 15:47:41 GMT

Ok i found a solution, all date in sf database are stored with datetime so i have to convert my date to datetime 2017-09-22T12:00:00.000Z (example) to have exactly 2017-09-22 and not 2017-09-21