I want to get the result of large epoch time to hours minutes and seconds.
Ex: Epoch time : 9386717.000000
Hours minutes seconds: 2607:25:17
How can I get the result?
Thanks in Advance.
Hi
Check this
| makeresults
| eval total_seconds="9386717.000000"
| eval temp =tostring(total_seconds, "duration")
| rex field=temp "((?<days>^[^+]+)\+){0,1}(?P<hour>[^:]+):(?P<minutes>[^:]+):(?P<seconds>[^.]+)"
| eval day_to_hour=if(days>0,days*24+hour,days)
| eval output=if(days>0,day_to_hour.":".minutes.":".seconds,hour.":".minutes.":".seconds)
| table output
| makeresults
| eval total_seconds="9386717.000000"
| eval Hours=floor(total_seconds / 60 /60), Minutes=floor((total_seconds%Hours)/60), Seconds=floor(total_seconds % 60)
How to convert large epoch time to hours minutes and seconds ?
→ How to convert huge seconds to hours minutes and seconds?
Hi
Check this
| makeresults
| eval total_seconds="9386717.000000"
| eval temp =tostring(total_seconds, "duration")
| rex field=temp "((?<days>^[^+]+)\+){0,1}(?P<hour>[^:]+):(?P<minutes>[^:]+):(?P<seconds>[^.]+)"
| eval day_to_hour=if(days>0,days*24+hour,days)
| eval output=if(days>0,day_to_hour.":".minutes.":".seconds,hour.":".minutes.":".seconds)
| table output
https://www.epochconverter.com/
your string is not epoch time, please check and correct your question.