DSXchange

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.

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

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

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'.

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.