Hello,
I am having trouble converting to Hour:Minute:Second format from epoch time
First i have made a subtraction which i want it to be in human readable format. But it's giving me wrong result. Below is my query.
|Stats max(_time) as LastBackup,min(_time) as StartBackup,sum(FileSize) as TotalBackupSize | eval TimeDiff=LastBackup-StartBackup| table StartBackup LastBackup TimeDiff|eval Total=strftime(TimeDiff,"%H:%M:%S")
StartBackup LastBackup TimeDiff Total
1 1375920004 1375929896 9892 04:44:5
But the value should be 2:44:5, Why am i getting such wrong result?
Any insight will be much appreciated.
... View more