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.
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.
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".
CLUCK LIKE A CHICKEN! Now look at this tiny ad:
free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth
