File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
JavaRanch » Java Forums » Java » Performance
Bookmark "JConsole csv time format?" Watch "JConsole csv time format?" New topic

JConsole csv time format?

J.D. Thompson

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':


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!!!

J.D. Thompson

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

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:
subject: JConsole csv time format?
jQuery in Action, 3rd edition