Calc date/time diff beween mysql timestamp and current time (pPhp)

stevegmag

😕
mySQL timestamp is format: "20031006143015".

I need to calc the day & time difference between the timestamp and the current time in a "0days 2hours 30mins 0sec" format.

I've tried date() and mktime() for the current time and various modifications to the timestamp, but I'm not getting any usable results when I try timestamp-currenttime.

This seems like something that would be a pretty common utlility? Can someone point me to some code examples? or onto better date/time functions?

thanks in advance

stevegmag

interesting....

why does my call to
$tmpTime = mktime($tmp); keep changing? // $tmp being a properly (re)formatted 'HismdY' date base on the mysql timestamp//

wouldn't I expect mktime to stay static if I'm seeding it with a static date?

$storedDateTime ='20031006143015';// string of timestamp stored in db
echo 'MySQL TimeStamp -- '.$storedDateTime.' ';
// is there a better way to do this part?
$tmpY = substr($storedDateTime, 0, 4);
$tmpM = substr($storedDateTime, 4, 2);
$tmpD = substr($storedDateTime, 6, 2);
$tmpH = substr($storedDateTime, 8, 2);
$tmpI = substr($storedDateTime, 10, 2);
$tmpS = substr($storedDateTime, 12, 2);
$tmp = $tmpH.','.$tmpI.','.$tmpS.','.$tmpM.','.$tmpD.','.$tmpY;
echo '"HisdmY" formatted date for mktime() -- '.$tmp.' ';
$tmpTime = mktime($tmp); // this value keeps changing even though the timestamp doesn't?
$curDateTime = time();
echo 'tmpTime (from mktime()) -- '.$tmpTime.'   ';
echo 'new Date (reversed tmpTime) -- '.date('YmdHis',$tmpTime).'   ';
echo 'curTime (from time())-- '.$curDateTime.'   ';
echo 'Current Time (reversed curTime)-- '.date('YmdHis',$curDateTime).'   ';

LordShryku

Is that timestamp from mySQL YmdHis? (Year,month,day,hours,minutes,seconds)

stevegmag

ok, found one problem...

changed
$tmp = $tmpH.','.$tmpI.','.$tmpS.','.$tmpM.','.$tmpD.','.$tmpY;
echo '"HisdmY" formatted date for mktime() -- '.$tmp.' ';
$tmpTime = mktime($tmp);

to:

$tmpTime = mktime($tmpH,$tmpI,$tmpS,$tmpM,$tmpD,$tmpY);

mktime does not take a string as a arg.

tekky

Originally posted by stevegmag
ok, found one problem...
.....
mktime does not take a string as a arg.

hehe, as stated on php.net...

int mktime ( [int hour [, int minute [, int second [, int month [, int day [, int year [, int is_dst]]]]]]])

😉