topic Re: How to convert the System timestamp to Epoch Unix timestamp in Talend Studio

How to convert the System timestamp to Epoch Unix timestamp

Anonymous — Sat, 16 Nov 2024 03:24:42 GMT

Hi,

How to convert the System timestamp to Epoch Unix timestamp in talend. Is there any function like java.util.Date.gettime() to convert it into milliseconds.

Meaning converting yyyy-MM-dd HH:mm:ss to unix epoch timestamp.

Example

2020/01/30 00:00:00 to Unix timestamp. Then i want to subtract the unix timestamp by 1 so that it can give me 1 sec less.

Can anyone help me in this ??

Thanks,
Abhishek

Re: How to convert the System timestamp to Epoch Unix timestamp

TRF — Thu, 30 Jan 2020 06:55:56 GMT

Have a look at TalendDate.addDate.
You just have to use it with a negative value.
https://help.talend.com/reader/~R4Lk_SlELw9a8pKBKTm9A/97HhybirKNimDaj6MWfaDg

Re: How to convert the System timestamp to Epoch Unix timestamp

Anonymous — Thu, 30 Jan 2020 07:05:04 GMT

But first i need to convert system timestamp into unix timestamp.

Re: How to convert the System timestamp to Epoch Unix timestamp

TRF — Thu, 30 Jan 2020 08:03:35 GMT

As far as I understand you question, you just have to do this:

TalendDate.addDate(TalendDate.getCurrentDate(), -1, "ss")

It will give you the current date minus 1 second.

Just store the result to a field with datatype Date or a global variable you have to cast to Date when you want to use the content.

Re: How to convert the System timestamp to Epoch Unix timestamp

Anonymous — Thu, 30 Jan 2020 08:52:03 GMT

Hi,

Say suppose today is 2020/1/29 00:00:00. By using

TalendDate.addDate(TalendDate.getCurrentDate(), -1, "ss")

i get the time 2020/1/28 11:59:59 pm. Then i convert this time to Epoch timestamp i.e into 1580255999.

Thanks,

Abhishek

Re: How to convert the System timestamp to Epoch Unix timestamp

TRF — Thu, 30 Jan 2020 10:10:17 GMT

To convert current date - 1 second in epoch:

TalendDate.addDate(TalendDate.getCurrentDate(), -1, "ss").getTime()

Re: How to convert the System timestamp to Epoch Unix timestamp

Anonymous — Fri, 31 Jan 2020 09:13:43 GMT

As my server is in PST time zone

getCurrentDate()

gives me that zone time, can i convert this into UTC time before converting into unix time.

Re: How to convert the System timestamp to Epoch Unix timestamp

TRF — Fri, 31 Jan 2020 09:24:14 GMT

This link may help:

https://stackoverflow.com/questions/35653484/how-can-i-convert-local-time-to-utc-and-vice-versa-in-a-talend-job

Re: How to convert the System timestamp to Epoch Unix timestamp

sam473 — Thu, 09 Jul 2020 08:33:00 GMT

What i should give in schema to get epochunixstamp

unix.JPG

Re: How to convert the System timestamp to Epoch Unix timestamp

sam473 — Thu, 09 Jul 2020 08:33:00 GMT

What i should give in schema to get epochunixstamp