Four Stars

Salesforce Date Conversion

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,

  • Data Integration
2 REPLIES
Seven Stars TRF
Seven Stars

Re: Salesforce Date Conversion

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

TRF
Four Stars

Re: Salesforce Date Conversion

User Timezone is PDT.

 

Thanks,