question Re: Nifi Epoch conversion not working? in Archives of Support Questions (Read Only)

Nifi Epoch conversion not working?

asabatino — Fri, 16 Sep 2022 14:00:33 GMT

Hi,

Can anyone shed some light on this, please.

having:

attribute 'epochdatetime' Value: '1545266262' and

using:

UpdateAttribute to create new variable 'converteddatetime' with

${epochdatetime:format("yyyy/MM/dd HH:mm:ss.SSS'Z'", "GMT")}

gives:

converteddatetime' Value: '1970/01/18 21:14:26.262Z'

instead of: December 20, 2018/12/20 12:37:42......

Re: Nifi Epoch conversion not working?

arald — Mon, 24 Dec 2018 16:21:40 GMT

Hi @A Sabatino,

I am not sure why you expect the date resulting from your epoch value. So from what I can see, your value is not what you expect, the conversion is fine.

In the API documentation (https://nifi.apache.org/docs/nifi-docs/html/expression-language-guide.html#dates) it is desribed, that the value ist interpreted in milliseconds from 1. January 1970 00:00:00 GMT. Now when interpreting '1 545 266 262', it results in something like 17.8 days. So a time on the 18. January 1970 seems to be the correct result. To me it appears as if you lost a factor of 1000 somewhere in your epoch value.

Regards
Harald

Re: Nifi Epoch conversion not working?

asabatino — Mon, 24 Dec 2018 17:28:08 GMT

Hi Harald

You are right - we passed in the epoch in seconds rather than milliseconds !

Many thanks

Regards

Aniello

Re: Nifi Epoch conversion not working?

arald — Mon, 24 Dec 2018 17:37:42 GMT

Hi @A Sabatino,

thanks for the info. Would be great if you click on 'accept' for the answer. Helps everyone to see the issue is resolved and provides you and me with a reward in terms of reputation points 🙂

Regards
Harald

Re: Nifi Epoch conversion not working?

AshuGang — Tue, 08 Feb 2022 03:28:45 GMT

Hi @A Sabatino,
I am also facing same issue for Value: '1643667489'
Could you please share complete syntax for the epoch(1643667489) in second....

Re: Nifi Epoch conversion not working?

VidyaSargur — Tue, 08 Feb 2022 05:56:09 GMT

Hi @AshuGang as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.