epoch datetime conversion

[manodwhb]

The epoch time is 1170321248 translates to : January 31st, 2007 04:14:08 PM in Talend,how we can achive this?

[manodwhb · Accepted solution]

i tried below syntax in tmap

(row1.myTimeColumn ==null || row1.myTimeColumn =="" )?null:
(new java.util.Date(Long.parseLong(row1.myTimeColumn) * 1000) );

[TRF]

Hi,
This link may help you https://community.talend.com/t5/Design-and-Development/How-to-convert-of-epoch-time-to-human-readabl...
Now you have to adapt it to the desired date format.

[TRF]

Does this help?

If so please mark this case as solved (Kudos also accepted).