Solved

Joda Time problem with Time Zones

Posted on 2010-09-22
17
529 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
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
powerN  challenge 3 47
countX 22 70
where is session ID cache stored 1 39
Java asynchronous logging 4 34
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…
For beginner Java programmers or at least those new to the Eclipse IDE, the following tutorial will show some (four) ways in which you can import your Java projects to your Eclipse workbench. Introduction While learning Java can be done with…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

757 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

19 Experts available now in Live!

Get 1:1 Help Now