question Re: Problem with transform date to long in nifi in Support Questions

Problem with transform date to long in nifi

MWM — Mon, 18 Dec 2023 10:57:46 GMT

Hi guys,

I have some problems with transform date from string to long in NIFI. I have date like this: "02-01-1968|" and I need to transform this to long. i am using UpdateAttribte Processor to format it to number like this: ${my_date:toDate("dd-MM-yyyy","GMT"):toNumber()})} but I have result like this: "my_date" : -63072000000 .Does anyone know how to solve this better?

Re: Problem with transform date to long in nifi

SAMSAL — Mon, 18 Dec 2023 13:45:52 GMT

Hi @MWM ,

The reason you are getting negative value is because the minimum date in epoch is "January 1st, 1970" which corresponds to "0". It turns out you can still convert the negative value back to date using the following expression:

${my_date:toDate():format("dd-MM-yyyy")}

If that helps please accept solution.

Thanks

Re: Problem with transform date to long in nifi

MWM — Mon, 18 Dec 2023 13:49:57 GMT

Hi @SAMSAL , Yes i can convert negative value back but i need to send this date as long to other system and this is my problem with converting this date to long in nifi using toNumber() because my value is negative

Re: Problem with transform date to long in nifi

SAMSAL — Mon, 18 Dec 2023 14:06:15 GMT

Is the problem that the other system doesnt take negative values?