Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JConsole csv time format?

 
J.D. Thompson
Greenhorn
Posts: 28
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 28
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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".
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic