insert duration into table

manjeman

hello all,

here is my scripts

function date_diff($datenow, $datelast) {
$s = strtotime($datenow)-strtotime($datelast);
$d = intval($s/86400);
$s -= $d86400;
$h = intval($s/3600);
$s -= $h3600;
$m = intval($s/60);
$s -= $m*60;
return array("d"=>$d,"h"=>$h,"m"=>$m,"s"=>$s);
}
$masa = "20020726 17:58:22";
$masa2 = "20020724 15:50:55";

$date_diff = date_diff($masa,$masa2);

echo "date diferent from $masa to $masa2 is 
day = ".$date_diff["d"]." 
hour = ".$date_diff["h"]." 
min = ".$date_diff["m"]." 
sec = ".$date_diff["s"]." ";

my scripts do fine with this result

date diferent from 020726 17:58:22 to 020724 15:50:55 is
day = 2
hour = 2
min = 7
sec = 27

but i have a problem how to insert and retrieve the value of day, hour, min and second into duration field because the datatype of the field is "number".

did anybody has any suggestion about this
problem??

please do not suggest me to change the datatype into something else...🙂

thanx in advance..

Anon

Hi,
can't you try something like:

<number> = day86400+hour3600+min*60+sec

and when retrieving:
x = number;
day = x / 86400;
x %= 86400;
hour = x / 3600;
...

it is even easier to do directly:
<number> = strtotime($datenow)-strtotime($datelast);

and to do the calculation when retrieving the field.

hope this help,
Pierre