Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Converting Epoch to TimeStamp of specific TimeZone

Highlighted

Converting Epoch to TimeStamp of specific TimeZone

New Contributor

I am trying to convert the epoch in milliseconds to TimeStamp of specific timezone.

I tried using "format" of nifi expression language as below in updateAttribute processor

${closed_epoch:format("yyyy", "GMT")}

But updateAttribute processor is showing error saying "unexpected token ','.

Is it the bug with Nifi expression language? and what is the timezone that Nifi uses by default when I try ${closed_epoch:format("yyyy")}?

Is there any other way to convert epoch to timestamp of specific timezone ?

2 REPLIES 2

Re: Converting Epoch to TimeStamp of specific TimeZone

What version of NiFi are you using? The timezone parameter was added in NiFi 1.2.0 / HDF 3.0 (NIFI-2908).

Re: Converting Epoch to TimeStamp of specific TimeZone

Super Guru

@Anil Reddy

In addition to Matt's answer if you want to know all supported Functions in Expression Language for your version of NiFi then click on Right Up Corner GlobalMenu Button

59400-globalmenu.png

And click on Help

59401-globalmenu-help.png

3.Then Click on Expression Language Guide

59402-expressionlanguage.png

on Right Side will shows up all the functions that are supported in your version of NiFi.

If you want to implement ${closed_epoch:format("yyyy", "GMT")} this expression even though it is not supported in your version of NiFi then as a work around you can use plus,minus functions.

Assuming your closed_epoch attribute value is 1453843201123

${closed_epoch:minus(86400000)} //this expression will minus 86,400,000 Milliseconds(i.e 24 hrs) from closed_epoch value.

New value for closed_epoch will be 1453756801123.

*if you are having DayLightSaving time then you need to change the milliseconds value in minus(or) plus function.


globalmenu.png