Determining Format of Inbound Timestamp field - Data Model and Stewardship Campaign

[Carolus_Holman]

Hi everyone, I am currently trying to get a correct Timestamp to show up on the Campaign Dashboard. I have determined that the inbound timestamp needs to be represented as a long datatype, and this needs to be converted to an EPOCH time from a traditional timestamp field. I am using PostgreSQL 10.7. When I extract the EPOCH time from the timestamp, then convert it back, I get the correct resulting timestamp, however when sending the EPOCH to the Data Stewardship campaign the result always comes back as some starting with 1970- .  

[Carolus_Holman · Accepted solution]

I figured out the Answer. Talend Expect a Long in Milliseconds. This should be in the documentation somewhere. Spent way to long on this issue.