Menu
Community /Pin to ProfileBookmark
@NogDogApr 22.2007 — #Using [url=http://www.charles-reace.com/PHP_and_MySQL/Time_Difference/]this function I created[/url] , you could do:
@NogDogApr 22.2007 — #Are you using [url=http://www.php.net/strtotime]strtotime()[/url] to convert the date or datetime string from the DB into a UNIX timestamp integer? Or if it's a MySQL database, you could use the [url=http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_unix-timestamp]UNIX_TIMESTAMP() function[/url] in your query.
Difference between two dates
I only want the difference between the dates to be displayed in the highest unit. For example, if it has been less than a minute between the two dates, the unit should be seconds; if less than a day’s difference between the dates, then the unit should be in hours; if less than a week, then the unit should be in days. I’ve searched everywhere, but could not find a solution. Thanks.
Sign in
to post a comment6 Comments(s) ↴
0
@NogDogApr 22.2007 — #Using [code=php]
<?php
/**
* array timeDiff(int $t1, int $t2)
* $t1 and $t2 must be UNIX timestamp integers, order does not matter
* returns array broken down into years/months/weeks/etc.
*/
function timeDiff($t1, $t2)
{
if($t1 > $t2)
{
$time1 = $t2;
$time2 = $t1;
}
else
{
$time1 = $t1;
$time2 = $t2;
}
$diff = array(
'years' => 0,
'months' => 0,
'weeks' => 0,
'days' => 0,
'hours' => 0,
'minutes' => 0,
'seconds' =>0
);
foreach(array('years','months','weeks','days','hours','minutes','seconds')
as $unit)
{
while(TRUE)
{
$next = strtotime("+1 $unit", $time1);
if($next < $time2)
{
$time1 = $next;
$diff[$unit]++;
}
else
{
break;
}
}
}
return($diff);
}
$diff = timeDiff(strtotime('2007-04-22 12:23:45'), strtotime('2009-07-23 15:12:00'));
$difference = "0 seconds"; // initialize just in case
foreach($diff as $unit => $value)
{
if($value)
{
if($value == 1)
{
$unit = substr($unit, 0, -1);
}
$difference = "$value $unit";
break;
}
}
echo "Time difference: $difference";
?>
[/code]0
@NogDogApr 22.2007 — #Are you using