Days difference between 2 Time-Stamps.

alphacat said:

Thanks.
Do you know another method for calculating days interval between two time-stamps?

Click to expand...

alphacat said:

Thank you for your answer.
I used the forumula written in wikipedia, the one of JD, and it miscalculates when I enter two days in different monthes, for example I entered (in format of m/d/y h:min:sec)
Time-stamp_1 = 2.28.2009, 00:00:00.
Time-stamp_2 = 3.1.2009, 00:00:00.
and TS2 - TS1 gave me 4.
You have any idea why?

Click to expand...

alphacat said:

They dont explain in the link you gave how they calculate it, so its not so helpful.

Click to expand...

alphacat said:

I receive: 2009-02-28 = JDN 2454890.94
and: 2009-03-01 = JDN 2454894.376875

Click to expand...

alphacat said:

Here is my calculation:
double JdnCalc(int day,int month,int year,int hour,int minute, int second)
{
double JD, JDN, a, y, m;

a = (14 - month)/12.0;
y = year + 4800 - a;
m = month + 12*a -3;
JDN = day + (153*m +2)/5.0 + 365*y + y/4.0 -y/100.0 + y/400.0 - 32045;
JD = (int)(JDN) + (hour-12)/24.0 + minute/1440.0 + second / 86400.0;
return(JD);
}

Whats wrong with it?

Click to expand...

double JdnCalc(int day,int month,int year,int hour,int minute, int second)
{
double JD, JDN, a, y, m;

a = [B]floor[/B]((14 - month)/12.0);
y = year + 4800 - a;
m = month + 12*a -3;
JDN = day + [B]floor[/B]((153*m +2)/5.0) + 365*y + [B]floor[/B](y/4.0) - [B]floor[/B](y/100.0) + [B]floor[/B](y/400.0) - 32045;
JD = (int)(JDN) + (hour-12)/24 + minute/1440 + second / 86400;
return(JD);
}