topic Re: How to convert Date Format into epoch time by using tMap? in Talend Studio

How to convert Date Format into epoch time by using tMap?

Anonymous — Sat, 16 Nov 2024 03:37:03 GMT

Hi, I have an Input which is "1900-01-01T00:00:00" that is a String and I need to convert it into epoch time which is long. How can I achieve this?

Re: How to convert Date Format into epoch time by using tMap?

Anonymous — Sat, 11 Jan 2020 03:39:13 GMT

Hi,

Please refer the below logic.

I cross verified the answer and it looks same as below.

The function used is as shown below.

(TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ss",row1.input_date).getTime())/1000

Please spare a second to mark the topic as resolved as it will help others during their reference 🙂

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: How to convert Date Format into epoch time by using tMap?

Anonymous — Tue, 14 Jan 2020 21:06:40 GMT

Hi Nikhil,

Thanks for your kind response and it helped to resolve the issue.

However, how to get the current local date into epoch time? What will be the function that I need to write in Expression Builder? Current Date Format would be ("yyyy-MM-dd"T"HH:mm:ss") that should be coverted into epoch time.

I would really appreciate your kind support. Thanks!

Re: How to convert Date Format into epoch time by using tMap?

Anonymous — Wed, 15 Jan 2020 00:34:28 GMT

Hi,

Since current time is already in date format, could you please try below?

(TalendDate.getCurrentDate().getTime())/1000

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved