How to convert the string Unix Timestamp to Oracle timestamp ( YYYY-MM-DD HH24:MI:SS)

[Anonymous]

Hi,

I have string Sent_time column( which is a Unix timestamp) coming from Rest Api data, i need to convert that string column into oracle timeStamp, that is (YYYY-MM-DD HH24:MIS) format. Please find the below image.

I have tried using - TalendDate.parseDate("yyyyMMdd",row1.sent_time)  , but it got converted to some other date which is not the actual date.

Can anyone help me in this, please note -Sent_time is a String datatype column.

Thanks,

Abhishek

[manodwhb · Accepted solution]

Please check the below link.

https://help.talend.com/r/en-US/8.0/tmap/tmap-tlogrow-tfileinputdelimited-tfileinputdelimited-conver...