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*