Salesforce.com (SFDC) date time format

anu123 · Post by **anu123** » Tue Feb 23, 2010 9:56 pm

date/time does not match across SFDC and DB after ETL process.

example:

SFDC created_date = 2009-01-28T06:28:58.000Z
DB Table created_date = 2009-01-28 11:28:58

As per the documentation SFDC stores date/time in UTC format. But after ETL process there is 5hr difference between SFDC and DB dates.
When I googled, I found UTC-5hr = EST but in my case it appears to be UTC+5 = EST.

Any one noticed similar behavior?

thanks in advance.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 23, 2010 10:48 pm

How did your ETL process the date? That is, precisely what transformations were effected?

chulett · Post by **chulett** » Wed Feb 24, 2010 8:06 am

Please also tell us what database this is and what your target column's data type is.

anu123 · Post by **anu123** » Fri Apr 02, 2010 2:58 pm

chulett wrote:Please also tell us what database this is and what your target column's data type is. ...

Thanks Craig.
Target database is Oracle 10g. Target column data type is 'TimeStamp'.

anu123 · Post by **anu123** » Fri Apr 02, 2010 3:01 pm

ray.wurlod wrote:How did your ETL process the date? That is, precisely what transformations were effected? ...

Ray,

ETL does not have any transformations. It is very basic ETL which has three stages as below.

SFDC_Stage------->Transformer------------->Oracle Enterprise Stage.