question Re: Converting Datetime to UnixEpoch time (milliseconds) in Archives of Support Questions (Read Only)

Converting Datetime to UnixEpoch time (milliseconds)

hyuen — Fri, 09 Sep 2016 03:26:38 GMT

Hello,

I'm currently converting csv files into avro and I'd like to store the date time stamps as unix (milliseconds). Is there a way to go about this in NiFi?

Thanks.

Re: Converting Datetime to UnixEpoch time (milliseconds)

dpinkston — Fri, 09 Sep 2016 04:00:45 GMT

@Harry Yuen your going to want to use "toNumber" in the NiFi expression Language. More information can be found here: https://nifi.apache.org/docs/nifi-docs/html/expression-language-guide.html#tonumber

Basically on your DateTime you'll want to cast:

${now():toNumber()}

This will output the UnixEpoch time.

Re: Converting Datetime to UnixEpoch time (milliseconds)

cstanca — Fri, 09 Sep 2016 06:16:29 GMT

@Harry Yuen

@Devin Pinkston is correct. If you were to convert a date string, you would have had to add also the input date format, for example:

${now():toNumber():format('yyyy-MM-dd')}