[anacy_nivas]

I did following coding to display date and time difference between two dates( $current_date, $data_ref). Date format is date("Y-m-d h-i-s").

$current_year = substr($current_date,0,4);
$current_month = substr($current_date,5,2);
$current_day = substr($current_date,8,2);
$current_hour = substr($current_date,11,2);
$current_min = substr($current_date,14,2);
$ref_year = substr($data_ref,0,4);
$ref_month = substr($data_ref,5,2);
$ref_day = substr($data_ref,8,2);
$ref_hour = substr($data_ref,11,2);
$ref_min = substr($data_ref,14,2);
$minutes_Diff = $ref_min-$current_min;
$hour_Diff = $ref_hour-$current_hour;
$day_Diff = $ref_day-$current_day;
$month_Diff = $ref_month-$current_month;
$year_Diff = $ref_year-$current_year;

Finally i get the date difference , Hour difference .
It is possible to calculate total minutes difference ?

[End User]

Lots of ways to do this....

PHP Code:

$to_time=strtotime($current_date);
$from_time=strtotime($data_ref);
echo round(abs($to_time - $from_time) / 60,2)." minute"; 

You could use this, although you'll need to convert your dates to mySQL timestamps:

PHP Code:

function totalTimeDiffMins($start, $end){
// returns difference between two 
// mysql timestamps as minutes

    $unix_timestamp1 = strtotime($end);
    $unix_timestamp2 = strtotime($start);

    // get difference between the two in seconds
    $time_period = ($unix_timestamp1 - $unix_timestamp2);
    
    if($time_period > 0){
        $time_in_mins = ($time_period / 60);
        return $time_in_mins;
    }else{
        return "DATE ERROR";
    }
} 

[Jcbones]

PHP Code:

$current_date = date("Y-m-d-h-i-s");

$date = explode('-',$current_date);

$year = $date[0];
$month = $date[1];
$day = $date[2];
$hour = $date[3];
$minute = $date[4];
$second = $date[5]; 

[End User]

I think he wanted to get the difference in seconds between two dates, unless I misread his post.

Originally Posted by Jcbones

PHP Code:

$current_date = date("Y-m-d-h-i-s");



$date = explode('-',$current_date);



$year = $date[0];

$month = $date[1];

$day = $date[2];

$hour = $date[3];

$minute = $date[4];

$second = $date[5]; 

[Jcbones]

I know, I was just showing an easier way to strip the time using explode(), rather than substr().

But, since you said something, I went ahead and created a function that may be useful.

Returns time difference from two timestamps. User decides calculation limits. I could take this to Years, but right now it is limited to Days and below.

PHP Code:

<?php

//set real dates for start and end, otherwise *nix the strtotime() lines.
//$return 'days' will return days/hours/minutes/seconds.
//$return 'hours' will return hours/minutes/seconds.
//$return 'minutes' will return minutes/seconds.
//$return 'seconds' will return seconds.
function timeDifference($start,$end,$return='days') {
    //change times to Unix timestamp.
    $start = strtotime($start);
    $end = strtotime($end);
        if($start > $end) {
            return 'Please make sure the start date is less than the end date.';
        }
    //subtract dates
    $difference = $end - $start;
    $time = NULL;
    //calculate time difference.
    switch($return) {
        case 'days':
             $days = floor($difference/86400);
                $difference = $difference % 86400;
                    $time .= $days . ' Days, ';
        case 'hours':
            $hours = floor($difference/3600);
                $difference = $difference % 3600;
                    $time .= $hours . ' Hours, ';
        case 'minutes':
            $minutes = floor($difference/60);
                $difference = $difference % 60;
                    $time .= $minutes . ' Minutes, ';
        case 'seconds':
            $seconds = $difference;
                $time .= $seconds . ' Seconds';
    }
    
    return $time;   
    
}

echo timeDifference('2008-06-13 14:39:28','2008-07-14 19:25:07','seconds');

?>

[wirehopper]

Just for fun ...

PHP Code:

$t=max($start,$end)-min($start,$end); 

... because that way, even if the user messes up the dates, the code works.