[SOLVED] Date Subraction

[timmah1]

I need to subtract two dates.

 

What's the easiest way of doing this?

 

I have this

$b = date("M j, Y H:i:s",$row6['date']) - date("M j, Y H:i:s",$row6['duration']);

Then display as this

echo date("M j, Y H:i:s",$b)

 

But it keeps showing up as Dec 31, 1969 18:00:00.

 

$row6['date']

$row6['dauration']

both fields are datetime (0000-00-00 00:00:00)

 

Thanks in advance.

[pdkv2]

If you are using MySql use DATEDIFF(date1,date2) in the select statement to delect the calculated date.!

[timmah1]

So right now, my select statement is this:

$today = date("Y-m-d H:i:s");
$items= "SELECT * FROM items WHERE duration >= '$today'";

 

How would I implement what you said?

[mmarif4u]

Try out this function OR can get more idea from http://my.php.net/datetime.if u want to use php.

 

<?php
Function DateDiff($date1,$date2) {
  $timedifference=$date2-$date1;
  $corr=date("I",$date2)-date("I",$date1);
  $timedifference+=$corr;
  return $timedifference;
}


$d1=mktime(2,0,0,10,28,2007);
$d2=mktime(4,0,0,10,29,2007);
$period=DateDiff($d1,$d2);
printf("<br>%s",date("I d.m.Y H:i",$d1));
printf("<br>%u hour",$period/3600);
printf("<br>%s",date("I d.m.Y H:i",$d2));
?>

 

To use mysql:

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

[pdkv2]

So right now, my select statement is this:

$today = date("Y-m-d H:i:s");
$items= "SELECT * FROM items WHERE duration >= '$today'";

 

How would I implement what you said?

 

 

<?php
$today = date("Y-m-d H:i:s");
$items= "SELECT DATEDIFF(date1,date2) FROM items WHERE duration >= '$today'";
?>

[timmah1]

I have this, but it's only displaying the year

$formatted_date = date("Y-m-d H:i:s", strtotime($myrow2['duration']));
$today = date("Y-m-d H:i:s");
$ends = $today-$formatted_date1;

[timmah1]

I used one of these examples, but nothing is displaying

 

$date1 = date("Y-m-d H:i:s");
$date2 = $myrow2['duration'];

function DateDiff($date1,$date2) {
  $timedifference=$date2-$date1;
  $corr=date("I",$date2)-date("I",$date1);
  $timedifference+=$corr;
  return $timedifference;
}

[timmah1]

ok, I got it to work, but call me dumb, but how do I get this to display like this

 

23 hours, 17 minutes?

 

Right now it displays like this:

Array ( [23] => hours [17] => minutes )

 

Here's the code

function date_diff($d1, $d2){
    $d1 = (is_string($d1) ? strtotime($d1) : $d1);
    $d2 = (is_string($d2) ? strtotime($d2) : $d2);

    $diff_secs = abs($d1 - $d2);
    $base_year = min(date("Y", $d1), date("Y", $d2));

    $diff = mktime(0, 0, $diff_secs, 1, 1, $base_year);
    return array(
          date("H", $diff) => "hours",
         (int) date("i", $diff) => "minutes",
    );
}

$a = date_diff("$d1", "$d2");

print_r($a);

 

[kenrbnsn]

With that array, you could do:

<?php
$tmp = array();
foreach ($a as $num => $what)
    $tmp[] = $num . ' ' . $what;
echo implode(', ',$tmp);
?>

 

Ken

[timmah1]

you lost me on that Ken.

[timmah1]

Nevermind, works now.

 

Thanks Ken