I have a table with a column that is an integer data type that contains Unix epoch time data.
Here is a sample of the data:
1298226724
1298226722
1298226723
Using this converter:
http://www.epochconverter.com/
I get the following:
Epoch Timestamps: 1298260810
GMT: Mon, 21 Feb 2011 04:00:10 GMT
Your timezone: Sunday, February 20, 2011 9:00:10 PM
This is the code I am using for checking for nulls and then doing the conversion:
(row1.myTimeColumn ==null || row1.myTimeColumn =="" )?null:
(TalendDate.parseDate("yyyy-MM-dd",row1.myTimeColumn));
My Input:|
My Output:
1298226724|1300-02-24T00:00:00
1298226722|1300-02-22T00:00:00
1298226723|1300-02-23T00:00:00
It looks like the month and the day is correct, but the year and the time don't seem to work.
I found these posts, but not sure what I should do differently:
http://www.talendforge.org/forum/postgallery.php?pid=21776&filename=1.png
https://community.talend.com/t5/Archive/Choose-between-two-tOracleConnection/td-p/179455
http://www.talendforge.org/forum/viewtopic.php?pid=35672