wood burning stoves 2.0*
The moose likes Performance and the fly likes JConsole csv time format? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Performance
Bookmark "JConsole csv time format?" Watch "JConsole csv time format?" New topic
Author

JConsole csv time format?

J.D. Thompson
Greenhorn

Joined: Mar 08, 2006
Posts: 28
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

Joined: Mar 08, 2006
Posts: 28
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

Joined: May 16, 2011
Posts: 1
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".
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JConsole csv time format?
 
Similar Threads
Unix OS on Windows Vista ?
back ground process id ??
refresh a JPanel automatically as time changes
unable to retrieve timestamp in my servlet
How to identify Auth method NTLMv1 or NTLMv2