Date comparison Question
| From: | admin at buskirkgraphics dot com | Date: | Mon, 07 Apr 2008 15:42:18 +0000 |
| Subject: | Date comparison Question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-272647@lists.php.net to get a copy of this message | ||
I am having a date time comparison issue.
I have statically set the values here. But the data is fed from the database, CaldTime is timestamp
and since it will not allow me to have 2 timestamps in the same table I set the CallEnd varchar(12).
Storing the data they seem to be the same for output. I checked hexadecimal and binary to look for
obscurities.
$sqldata['CaldTime'] = "2008-04-07 11:15:32";
$sqldata['CallEnd'] = "2008-04-07 11:17:17";
$time1 = strtotime("$sqldata[CaldTime]");
$time2 = strtotime("$sqldata[CallEnd]");
$interval = $time2 - $time1;
echo $interval;
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
Displays like 1.75:0
I am looking for a more precise time like 1:45 instead.
Am I looking at this all wrong for time difference?
Richard L. Buskirk
Sorry my murloc got pawned in AV, and ever since I cant think right!