CODEWITHSUNDEEP
javaexceldatetimetimezone
alltestgreen
alltestgreen

Reputation: 149

Days passed between two java date with different timezone

I got two Date but one is CET and the other is CEST.

   Calendar calFrom = Calendar.getInstance();
            calFrom.set( 2013, 2, 20,0,0,0);
            Calendar calTo = Calendar.getInstance();
            calTo.set( 2013, 3, 5,0,0,0);

        long daysPassed= (calTo.getTime().getTime() - calFrom.getTime().getTime()) / (1000 * 60 * 60 * 24);
        System.out.println("calFrom: " + calFrom.getTime());
        System.out.println("calTo: " + calTo.getTime());
        System.out.println("daysPassed: " + daysPassed);

The output says:

calFrom: Wed Mar 20 00:00:00 CET 2013
calTo: Fri Apr 05 00:00:00 CEST 2013
daysPassed: 15

However Microsoft excel says the difference between the two days is 16!

How it is possible to calculate the days passed like Excel?

Upvotes: 0

Views: 478

Answers (1)

alltestgreen
alltestgreen

Reputation: 149

JodaTime seems like to handle this issue: http://kodejava.org/how-do-i-get-number-of-days-between-two-dates-in-joda/

Upvotes: 2

Related Questions