This content has been marked as final. Show 4 replies
Here's one way:1 person found this helpful
Import your reqlog into Excel. Use spaces as delimiters. Insert a column B and enter this formula: =(((A1/1000/60)/60)/24)+(-8/24)+DATE(1970,1,1)
That should give you a human readable reqlog to work with.
By the way, the 8/24 is my timezone offset - I'm in the Pacific time zone, hence -8. You should adjust to match your server's TZ.1 person found this helpful
This is helpful, and it works.
Any way I get the output to show seconds? The format selections for Time in Excel do not have one which includes seconds.
If I am at the point in my trouble shooting, that I am looking a the request log, I most likely will need seconds.
Strange, the default Time setting should be hh:mm:ss. Try setting it to custom and using "dd/mm/yyyy hh:mm:ss" (without quotation marks) as the format. Also useful is the Epoch Converter website, http://www.epochconverter.com/ - just remove the last three digits (as the Dgraph request log includes milliseconds).