Solved

Joda Time problem with Time Zones

Posted on 2010-09-22
17
532 Views
Last Modified: 2012-05-10
Hi Experts,

I m having this piece of code, i use Joda time 1.4jar and the code produces wrong results for one time zone and the correct results for other time zone.

Any ideas why? Attached code

Calendar startCalendar = Calendar.getInstance();
		      Calendar endCalendar = Calendar.getInstance();
		    
		      SimpleDateFormat sdf = new SimpleDateFormat("E MMM dd HH:mm:ss z yyyy");
		      try{
		    	  startCalendar.setTime(sdf.parse("Mon Sep 13 00:00:00 GMT+08:00 2010"));	    	  
		    	  endCalendar.setTime(sdf.parse("Tue Nov 30 00:00:00 GMT+08:00 2010"));
	      
		      }catch(Exception e){
		    	  e.printStackTrace();
		      }

 long timeA = endCalendar.getTimeInMillis();
		      long timeB = startCalendar.getTimeInMillis();
		      int daysInYear = startCalendar.getActualMaximum(Calendar.DAY_OF_YEAR);

  Period period = new Period(timeA - timeB,PeriodType.days());
		      System.out.println("Period Hours --> "+ period.getHours());
		      System.out.println("period.getDays()=[" + (period.getDays()+1) +']');

Open in new window


period.getDays() appear to be 0.

-Murali*
0
Comment
Question by:Murali Murugesan
  • 9
  • 5
  • 3
17 Comments
 
LVL 92

Expert Comment

by:objects
ID: 33740564
what are the value of timeA and timeB
0
 
LVL 13

Author Comment

by:Murali Murugesan
ID: 33740607
time A = 1291046400000
time B = 1284307200000
0
 
LVL 13

Author Comment

by:Murali Murugesan
ID: 33740639
Period period = new Period(timeB,timeA,PeriodType.days());

Changing the code as this works.. But the problem is without changing any code and when executed from a US time zone the first code works.
0
 
LVL 92

Expert Comment

by:objects
ID: 33740688
thats an old version of joda, have you tried running it on the latest?
0
 
LVL 13

Author Comment

by:Murali Murugesan
ID: 33740695
tried with 1.5 and its the same result... not working
0
 
LVL 13

Author Comment

by:Murali Murugesan
ID: 33740705
even with 1.6 nothing changed :(
0
 
LVL 13

Author Comment

by:Murali Murugesan
ID: 33741369
ok finally got some insight by getting into the source code. My Time Zone value has a problem.
Its Asia/Singapore, but for some reason the Joda doesn't consider this as a valid time zone for converting milliseconds into days.

By setting the Timezone as Mexico or China , i can make the code work without any other changes.

0
 
LVL 92

Expert Comment

by:objects
ID: 33741658
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 86

Expert Comment

by:CEHJ
ID: 33742147
Try
        Period period = new Period(startCalendar.getTimeInMillis(), endCalendar.getTimeInMillis(), PeriodType.hours());

        System.out.println("Period Hours --> " + period.getHours());

Open in new window

0
 
LVL 13

Author Comment

by:Murali Murugesan
ID: 33743589
@CEHJ

It works with hours. Even days work in this.. but not for the default one...
0
 
LVL 13

Author Comment

by:Murali Murugesan
ID: 33743622
@objects,

 tz updater tool doesn't work either.
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 33752532
>>but not for the default one...

What do you mean by that?
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 33763355
My last question not answered
0
 
LVL 13

Author Comment

by:Murali Murugesan
ID: 33766489
new Period(timeA - timeB,PeriodType.days())

this the default constructor that we are using across our code. I was mentioning that this was not working.

new Period(a,b,[days,hours,months]); -- etc... seems to work correctly. But new Period(a,[days]) has a problem, since it does some evaluation based on the local time zone.

-Murali*

0
 
LVL 86

Accepted Solution

by:
CEHJ earned 500 total points
ID: 33769390
It's nothing to do with timezones - it's to do with how you use the API (not the most intuitive). You should fine the following works fine:

	Period period = new Period(timeA - timeB,PeriodType.standard());

	System.out.println("Period Std Hours --> "+ period.toStandardHours().getHours());

	System.out.println("Period Std Days --> "+ period.toStandardDays().getDays());

Open in new window

0
 
LVL 13

Author Comment

by:Murali Murugesan
ID: 33775313
@ CEHJ:

That worked perfectly. But the problem is we are using JODA 1.4 and the one you shown above is from JODA 1.5.

I have a given a try with 1.5 and it works perfectly.

Thanx
-Murali*
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 33777429
:-)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
bitbucket vs gitbucket 3 57
servlet  URL Rewriting 1 25
javap bin 2 25
Groovy problem when using SOAPUI : DispatchException occurred 7 27
An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now