Ten Stars

epoch datetime conversion

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

Manohar B
1 ACCEPTED SOLUTION

Accepted Solutions
Ten Stars

Re: epoch datetime conversion

i tried below syntax in tmap

 

 

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

Manohar B
3 REPLIES
Ten Stars

Re: epoch datetime conversion

i tried below syntax in tmap

 

 

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

Manohar B
Thirteen Stars TRF
Thirteen Stars

Re: epoch datetime conversion

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
Thirteen Stars TRF
Thirteen Stars

Re: epoch datetime conversion

Does this help?

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


TRF