Converting Datetime to UnixEpoch time (milliseconds)

[#1]

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.

[#2 · Accepted solution]

@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.

[#3]

@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')}