topic Date Java issue in Talend Studio

Date Java issue

Anonymous — Sat, 16 Nov 2024 14:04:22 GMT

Hello !
This drives me crazy !!!!
I'm trying to define 2 java functions, one to calculate the numbers of days between 2 dates, one to add a certain number of days to a date.
Here are my functions:

    public static int getDateDifferenceInDays (Date firstDate, Date secondDate) {
    	long diff;
    	diff = secondDate.getTime() - firstDate.getTime();
    	diff /= (24L * 3600L * 1000L);
    	return (int)diff; 
    }
    public static Date addNumberOfDays (Date referenceDate, int numberOfDays) {
    	  long diff, toAdd;
    	  Date result;
    	  diff = referenceDate.getTime();
    	  diff += numberOfDays * 24L * 3600L * 1000L;
    	  result.setTime(diff);
    	  return result;     	 
    }

When I test the functions, by calculating the difference between today and a date to 2009-03-29 it works.
BUT, when I calculate '2009-03-30' - '2009-02-17' it give 40 days (instead of 41)....
I think this is because of a round error (during cast), but... how can I do ??
Thanks
Arnaud

Re: Date Java issue

Anonymous — Tue, 17 Feb 2009 16:46:02 GMT

hi,
perhaps you could find some "good methods" Calendar class in Calendar class like add() method (to add and substract).
but not sure about it
++

Re: Date Java issue

_AnonymousUser — Wed, 18 Feb 2009 06:53:54 GMT

Google is your friend:
search: java add days to date
search: java days between 2 dates
Your answer is there for the taking.
StijnM.

Re: Date Java issue

Anonymous — Wed, 18 Feb 2009 07:40:59 GMT

Yes, it is... but it can also give me some results that looks good at first sight ! I found many examples where the difference was good if the number of days was less than 40 days, but, when I tried with a date difference that should be 41 days, I got a wrong result (40).
But, I finally found, in the results of your keywords (different from mine). My problem was a round error, solved by adding an hour...
Thank you StijnM