JConsole csv time format?

[J.D. Thompson]

When I click on the graph to save the data in JConsole and look at the time corresponding to the data, for April 17, 2008 10:44:03 I see the following 'time':

39555.44726

I have tried to correlate this to a long, the number of seconds since the Java Epoch(1/1/1970 00:00:00) and failed to find a correlation.

Can anyone help me cipher this?

Thank you in advance for your time!!!

JD

[J.D. Thompson]

OK, I have the answer and am posting in case someone else experiences the same issue.

The short answer is: this is the serial number format MS Excel uses behind the scenes to store date/time information. It is based on the number of days since 1/1/1900.

[Andreas Hillmann]

The jconsole manual leads to the right solution: just format the time column appropriate.

If your locale like mine doesnt use "." (dots) as decimal separator, you have to do a additional step(s). In Excel 2003 before you import first rename the file extension to ".txt". Then for a german localized Excel you have to choose for the time column the "." as decimal separator and choose the ' (single quote) as 1000er separator. While you import the file left the time column format as "standard".

Then I have choosen format userdefined with the format string "TT.MM.JJJJ hh:mm:ss".