My input contains dateTime with hours like below.,

*No,DateTime,Name,ID*
*1,23.01.2016 09:02:21,Mega,201*
*2,03.01.2016 10:02:23,Hema,202*

Now i need to get 2nd Column ["02.01.2016 10:02:23"] and then compare it
with current dateTime with milliseconds.

After that if 2nd Column is in between past 72 hours and then insert into
sql server.

*For example.,*

                 My Current DateTime is "*04.01.2016 10:23:21"*

                For 1st row.,

                                     1,*23.01.2016 09:02:21*,Mega,201

                                    =>Compare *23.01.2016 09:02:21*
with *04.01.2016
10:23:21 [Current Time].It couldn't insert into SQL Server due to *
*DateTime*
* is not past 72 hrs when it
   compared  with current dateTime.                  *
                For 2 nd row,





*2,03.01.2016 10:02:23,Hema,202                                   =>This
Should be insert into SQL Server.Because it's date is "03.01.2016" and it
is past 72 hour data by compare it with current datetime.*

*How can i achieve my use case in Nifi Processors?*

*Please stop me if anything am doing wrong,*

*Thanks,*
*prabhu*

Reply via email to