How to find difference between two Joda-Time DateTimes in minutes

Question

Below is the method I wrote:

public List<Map<String, Object>> loadNotYetInEmployee(int shift, Date date,
        int transitionVal, String type, User user) {

    DateTime datetime = new DateTime(date);
    datetime = datetime
            .plus(Period.minutes(shiftTiming.getSession1InTime()));

    List<Map<String, Object>> result = new ArrayList<Map<String, Object>>();

    sql = SqlMapUtils.getSql("attendance.attendancestatus.latein",
            parameters);
    result = getJdbcTemplate().queryForList(sql);
    for (int i = 0; i < result.size(); i++) {
        Date punchInTime = (Date) result.get(i).get("punchtime");
        DateTime punchTime = new DateTime(punchInTime);
    }
    return result;
}

Now from my method you can see I have a Joda-Time DateTime object in object named datetime and from my result I am getting one timestamp which I am converting to jodatime punchTime. Now I want to find out the diff between these two dates, how do I do that?

[Minutes#minutesBetween](http://tinyurl.com/9bvfzxy)is your friend. — Luiggi Mendoza, Oct 12 '12 at 04:01
But this will only work if your DateTime objects are in the same TimeZone. — Bitcoin Cash - ADA enthusiast, Aug 16 '13 at 04:38
[`Days.daysBetween(d1, d2)`](http://joda-time.sourceforge.net/apidocs/org/joda/time/Days.html) is the neighbour of your friend — Shubham Chaudhary, Jun 18 '19 at 19:25

score 481 · Answer 1 · edited Apr 01 '14 at 18:46

481

Something like...

DateTime today = new DateTime();
DateTime yesterday = today.minusDays(1);

Duration duration = new Duration(yesterday, today);
System.out.println(duration.getStandardDays());
System.out.println(duration.getStandardHours());
System.out.println(duration.getStandardMinutes());

Which outputs

1
24
1440

or

System.out.println(Minutes.minutesBetween(yesterday, today).getMinutes());

Which is probably more what you're after

edited Apr 01 '14 at 18:46

Jacek Laskowski

72,696
27
242
420

answered Oct 12 '12 at 03:59

MadProgrammer

343,457
22
230
366

Does the above take into account time zones? Or should I convert to UTC / GMT first? – Doo Dah Apr 21 '16 at 01:15
@DooDah That's a good question, I "believe" that it does (as JodaTime has the concept of `LocalTime`), but I would suggest you test it and see. The question would be though, in which time zone would the resulting value be represented in? – MadProgrammer Apr 21 '16 at 01:24
I will test and figure this out. For me, the resulting timezone will likely be the server the code is running on. I am implementing a scheduled queue and will need to compute the amount of time between now and some future time based on a date from another time zone. I will report back what I find. – Doo Dah Apr 21 '16 at 01:29
2

I agree, this should have been the selected answer. Its neat and simple. – Sid Jan 09 '18 at 12:12
Creating a new Duration object just to get a time difference just isn't cool. Imagine having to perform a time difference on a large array of date/time objects. – Johann Jun 16 '18 at 07:20
@AndroidDev Given the fact that it's more accurate then "manual" calculating the result, I would say it's a better solution, besides if it's "really uncool", you could just do `long diffInMinutes = ChronoUnit.MINUTES.between(fromdate, todate);` and not care – MadProgrammer Jun 16 '18 at 08:34
Lemme slip in `Days.daysBetween(d1, d2)` which might be helpful to some. – Shubham Chaudhary Jun 18 '19 at 19:22

alfredaday · Accepted Answer · 2014-02-01T07:49:03.263

84

This will get you the difference between two DateTime objects in milliseconds:

DateTime d1 = new DateTime();
DateTime d2 = new DateTime();

long diffInMillis = d2.getMillis() - d1.getMillis();

edited Feb 01 '14 at 07:49

answered Oct 12 '12 at 04:01

alfredaday

2,048
18
14

80

The answer by MadProgrammer should have been the Accepted Answer. Notice the simple use of `Minutes.minutesBetween`. – Basil Bourque Feb 19 '14 at 09:28
5

No I disagree, it's too wordy and unclear: "The minutes minutes between punch time date time" is worse than "second date milliseconds minus first date milliseconds" – Coder Guy Feb 19 '15 at 23:11
5

This wil not take daylight savings into account. – Sander Versluys Sep 19 '17 at 07:34

score 11 · Answer 3 · answered Feb 06 '18 at 20:02

11

Something like...

Minutes.minutesBetween(getStart(), getEnd()).getMinutes();

answered Feb 06 '18 at 20:02

Carlos Chaguendo

2,895
19
24

Fails if the start and end date are really far apart (greater than size of int) – dannyRods Jan 09 '20 at 17:55

score 6 · Answer 4 · answered Mar 08 '19 at 21:58

DateTime d1 = ...;
DateTime d2 = ...;
Period period = new Period(d1, d2, PeriodType.minutes());
int differenceMinutes = period.getMinutes();

In practice I think this will always give the same result as the answer based on Duration. For a different time unit than minutes, though, it might be more correct. For example there are 365 days from 2016/2/2 to 2017/2/1, but actually it's less than 1 year and should truncate to 0 years if you use PeriodType.years().

In theory the same could happen for minutes because of leap seconds, but Joda doesn't support leap seconds.

How to find difference between two Joda-Time DateTimes in minutes

4 Answers4

Linked

Related