nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Juan Pablo Gardella <>
Subject Re: Cannot convert to timestamp error using putsql processor NiFi 1.3.0
Date Fri, 13 Oct 2017 16:16:53 GMT
I use UpdateAttribute->***->ConvertJSONToSQL->PutSQL

The attribute that is required to be stored as timestamp in DB, I convert
to timestamp at UpdateAttribute. For example:


Where myAttribute is a string that represents a date. Check
more information. It shows some JIRAs fixed in nifi 1.4.0, so this was the
reason I suggested to test at 1.4.0.

To don't fight against formats, I took the approach to convert to timestamp
before putting in DB.


On Fri, 13 Oct 2017 at 12:21 rakesh <> wrote:

> Hi Juan Pablo Gardella,
> Thanks for your reply.
> I tried with 1.4.0 as per your suggestion but still same issue.I'm not
> getting any clue of your other suggstion  I tried like
> "${sql.args.28.value:toDate():toNumber()}" like this in Update Attribute
> Processor but didn't work. Could you please explain bit more.
> --
> Sent from:

View raw message