Difference in date.?

[miles_rich]

how would you work out the differnce in seconds between

21/10/2002 12:00:00

and

22/10/2002 13:30:00

????

anyideas?

[miles_rich]

help me please

[buck2bcr]

This may be a little long winded however it will work.

// put your dates into a string
$date1 = "21/10/2002 12:00:00";
$date2 = "21/10/2002 13:30:00";

//strtotime doesn't recognize your format need to
//split the variable into component parts using explode
$date_exp1 = explode(" ",$date1);
$date_exp2 = explode(" ",$date2);

$day_exp1 = explode("/",$date_exp1[0]);
$day_exp2 = explode("/",$date_exp2[0]);

$month1 = $day_exp1[1];
$day1 = $day_exp1[0];
$year1 = $day_exp1[2];

$month2 = $day_exp2[1];
$day2 = $day_exp2[0];
$year2 = $day_exp2[2];

$time1 = $date_exp1[1];
$time2 = $date_exp2[1];

//using components make date string that strtotime can
//recognize
$new_date1 = "$month1/$day1/$year1 $time1";
$new_date2 = "$month2/$day2/$year2 $time2";

//use strtotime to get a stamp associated with date
$one = strtotime("$new_date1");
$two = strtotime("$new_date2");

//subtract one from the other to get difference
$second_diff = $two - $one;

//print out to make sure
print($second_diff);

HTH

[daarius]

$seconds1 = strtotime($dateSource1);
$seconds2 = strtotime($dateSource2);

$result = $seconds2 - $seconds1;

simple as that.

[buck2bcr]

Originally posted by daarius

$seconds1 = strtotime($dateSource1);
$seconds2 = strtotime($dateSource2);

$result = $seconds2 - $seconds1;

simple as that. [/B]

I initially tried to do that and using his date string didn't work. I got different dates when checking the stamp that was made.

First String orig = 21/10/2002 12:00:00 stamp = 1063213200 date from stamp = 2003-09-10 12:00

Second string orig = 22/10/2002 13:30:00 stamp = 1065810600 date from stamp = 2003-10-10 01:30

so maybe I had something wrong, but the date format dd/mm/yyyy hh:mm didn't give the correct timestamp.