Two Laptop Bag
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 Introducing JavaFX 8 Programming this week in the JavaFX forum!
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?
It's not a secret anymore!