@gcusello Thanks for your response this helps. I am getting diff in the string format example 00:01:12 --> This say 1 hour and 12 mins 30+03:46:11--> This say 30 days and 3 hours 46 mins I want to convert this diff to number of hours and compare it with a threshold(is a numeric value like 24) when I am trying this it is not giving me correct value. I understand this is due to the fact that "diff" is in string format. Shall I first take the diff in epoch and find the diff and then convert it using strf function? Please assist me on the same. trying query
| eval
currentEventTime=strftime(_time,"%Y-%m-%d %H:%M:%S"),
currentTimeintheServer=strftime(now(),"%Y-%m-%d %H:%M:%S"),
test_now=now(), test_time=_time, diff_of_epochtime=(now()-_time),
diff=strftime(diff_of_epochtime,"%Y-%m-%d %H:%M:%S"),
difforg=tostring(round(diff), "duration")
... View more