Issue with strftime time function. It always adds few minutes to actual results

[abochare]

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

[to4kawa]

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.

[to4kawa]

Is there any reason not to paste the query as text?

[vnravikumar]

Hi

check with

...your query..| eval diff = tostring((tNow - maxLastTime), "duration")