Time between dates

[Cagez]

I'm using a function to calculate the time between two dates, but its not working too well, negative numbers and such.

    function dateDiff($date, $date2 = 0)
    {
        if(!$date2)
            $date2 = mktime();

    $date_diff = array('seconds' => '',
                       'minutes' => '',
                       'hours'   => '',
                       'days'    => '',
                       'weeks'   => '');


    $tmp = $date - $date2;

    $date_diff['weeks']   = floor($date_diff['seconds']/604800);
    $tmp -= $date_diff['weeks'] * 604800;

    $date_diff['days'] = floor($tmp/86400);
    $tmp -= $date_diff['days'] * 86400;

    $date_diff['hours'] = floor($tmp/3600);
    $tmp -= $date_diff['hours'] * 3600;

    $date_diff['minutes'] = floor($tmp/60);
    $tmp -= $date_diff['minutes'] * 60;

    $date_diff['seconds'] = $tmp;

    return $date_diff;
}

[tekky]

ouch man you are going about it the hard way....

function datediff($d1, $d2=0)
{
     list($month, $day, $year) = explode("-", $d1); //get month-day-year vars
     $d1 = mktime(0,0,0, $month, $day, $year); //set d1 from mm-dd-yyyy format to midnite of that day unix timestamp
     $d2 = mktime(0,0,0, date("m"), date("d"), date("Y")); //this sets d2 to midnite of today //set d2 to midnite of today
     if($d1 < $d2) { $diff = $d2-$d1; } // normal for days in the past
     else { $diff = $d1-$d2; } // reverse for days in the future
     return $diff/86400; //time between days divided by 1 day (in seconds)
}

note: not tested but looks legit in my head....

[Cagez]

I'd like to stick to timestamps though and I may need to work with seconds/hours.

[tekky]

function counttime($t)
{
     $ticks = array(604800,86400,3600,60,1); //array for week/day/hour/min/sec
     $longt = array('week','day','hour','minute','second'); //array to translate numbers to time....
     for($i=0;$i<sizeof($ticks);$i++) // loop through ticks array
     {
          $temp = intval($t/$ticks[$i]); //get the intergral number of that tick in the remainder of seconds left, remaining is passed on to next tick set
          if ($t >= $ticks[$i]) // if $t isnt equal or greater than, then none of that tick type
          {
               $r .= $temp. " " .$longt[$i]. ($temp==1 ? "" : "s"). " "; //build the long text
               $t = $t-$temp*$ticks[$i]; //subtract integral amount of tick type * number of tick types to leave only the remaining time for the next tick type
          }
     }
     return $r;
}

function datediff($d1, $d2=0)
{
     $d2 = mktime(0,0,0, date("m"), date("d"), date("Y")); //this sets d2 to midnite of today //set d2 to midnite of today
     if($d1 < $d2) { $diff = $d2-$d1; } // normal for days in the past
     else { $diff = $d1-$d2; } // reverse for days in the future
     couttime($diff); //call the function above to convert into long text format
}

Hope this one works.... I dont see why it wont but I could be wrong....

[Cagez]

I got my way to work :p I've added to it, now it gives relative times ("Its been 6 days, 2 hours and 3 seconds") and total time ("There has been a total of 2 days, 48 hours and 172800 seconds").

    function dateDiff($date, $date2 = 0)
    {
        if(!$date2)
            $date2 = mktime();

    $date_diff = array('seconds'  => '',
                       'minutes'  => '',
                       'hours'    => '',
                       'days'     => '',
                       'weeks'    => '',

                       'tseconds' => '',
                       'tminutes' => '',
                       'thours'   => '',
                       'tdays'    => '',
                       'tdays'    => '');

    if($date2 > $date)
        $tmp = $date2 - $date;
    else
        $tmp = $date - $date2;   
    $seconds = $tmp;

    // Relative //////////////////////////////////////
    $date_diff['weeks'] = floor($tmp/604800);
    $tmp -= $date_diff['weeks'] * 604800;

    $date_diff['days'] = floor($tmp/86400);
    $tmp -= $date_diff['days'] * 86400;

    $date_diff['hours'] = floor($tmp/3600);
    $tmp -= $date_diff['hours'] * 3600;

    $date_diff['minutes'] = floor($tmp/60);
    $tmp -= $date_diff['minutes'] * 60;

    $date_diff['seconds'] = $tmp;
    // Total /////////////////////////////////////////
    $date_diff['tweeks'] = floor($seconds/604800);
    $date_diff['tdays'] = floor($seconds/86400);
    $date_diff['thours'] = floor($seconds/3600);
    $date_diff['tminutes'] = floor($seconds/60);
    $date_diff['tseconds'] = $seconds;

    return $date_diff;
}

[winterbeef]

If you're using timestamps, you can just subtract them and get the seconds:

//snippet
$delta = abs($date1 - date2);
$delta_days  = floor($delta/ (60*60*24));
$delta_seconds = $delta%(60*60*24);
$direction = ( $date1 > $date2 ? 'date1 later' : 'date1 earlier' );
//snippet

Am I missing something?

HTH

[Cagez]

Thats what I've done, but put each into it into an array so I have not only seconds, but specific increments of time, like a minute, hour, day week. Then I went further then that and got the amounts of time relative to each other.