Hi Team,
I have gone through the forum but couldnt find which suits my requirement.
We are trying to calculate time differences, for which I am using strftime. but if i am using strftime it always adds few minutes to expected results. Can anyone please explain what is wrong with it? Attaching 2 screenshots for reference
cf. https://en.wikipedia.org/wiki/Unix_time
UNIX time starts at 00:00:00 on January 1, 1970 as "1".
strftime(hoo,"%M")
If hoo is a small number, it must be a value between 00 and 59 .it is a letter.
round() /60
Since this is divided by 60, it will inevitably take smaller numbers.
The result is different because the operation being performed is different.
Is there any reason not to paste the query as text?
Hi
check with
...your query..| eval diff = tostring((tNow - maxLastTime), "duration")