topic Re: Conversion from EPOCH milliseconds to Date in Talend Studio

Conversion from EPOCH milliseconds to Date

Anonymous — Wed, 07 Mar 2018 09:10:05 GMT

Hi,

I have some epoch numbers stored as type long in milliseconds.

examples are:

1517408220000

1456932600000

Using an online converter (https://currentmillis.com/) i get the following which is correct:

Wed Jan 31 2018 14:17:00

Wed Mar 02 2016 15:30:00

What would the expression be to do this within a TMap, although i would want the output formatted differently as dd/mm/yyyy.

Please could anyone assist me.

Thank you

Re: Conversion from EPOCH milliseconds to Date

TRF — Wed, 07 Mar 2018 09:14:19 GMT

Hi,

This answer from @rhall may help you.

https://community.talend.com/t5/Design-and-Development/How-to-convert-of-epoch-time-to-human-readable-format/td-p/21634

Re: Conversion from EPOCH milliseconds to Date

manodwhb — Wed, 07 Mar 2018 09:46:19 GMT

you can use below way in tmap.
new java.util.Date((long)(row1.Epoch*1000)/1000)

i just created a job for you,please check the job

epochdate.zip

Re: Conversion from EPOCH milliseconds to Date

Anonymous — Wed, 07 Mar 2018 10:02:40 GMT

Thank you. I followed this before and realised now that i needn't multiply by 1000.

Re: Conversion from EPOCH milliseconds to Date

CSharma1636705679 — Wed, 08 Dec 2021 11:03:20 GMT

Hello, Sir how can I convert this into GMT0 I followed your solution and got successful in converting epoch time into timestamp but it is taking my system's timeZone how can I set it to take GMT0 !! please Help

Thanks