Timestamp in log

  • Resolved DonHaggard

    (@donhaggard)


    9 years, 4 months ago

    Can you please point me to a description of how to interpret the Date/Time Stamp field in the log table? And/or an Excel formula to convert it to an Excel Date/Time “serial number.” This would be of great help in analyzing the log file.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author gioni

    (@gioni)

    9 years, 4 months ago

    Hi DonHaggard!

    If you mean field “stamp” in the DB table it is Unix GMT timestamp with microsecond precision. Do you want to get it in some specific format? What is Excel Date/Time “serial number.”?

    Thread Starter DonHaggard

    (@donhaggard)

    9 years, 4 months ago

    Yes “stamp” in the DB table is the field to which I referred. Your response will help.

    The Microsoft Excel Date/Time “serial number” is described here. I will work on finding a similar description of the Unix timestamp and then see if I can come up with a formula to convert it to an equivalent Excel value. Excel will then be able to display the value in any desired Date/Time format.

    Thanks for the response.

    Plugin Author gioni

    (@gioni)

    9 years, 4 months ago

    You know, those guys from MS always invent “something special” and incompatible with the rest of the world.
    From my understanding you want to export log records into a file and then analyze them in Excel. So, it’s better to have ability to get those records with some date format that can be understandable by Excel. I’m going to add log export feature in one of the next release soon.
    For now you can use an approach like this: http://spreadsheetpage.com/index.php/tip/converting_unix_timestamps

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Timestamp in log’ is closed to new replies.