Re: Date comparison Question
| From: | admin at buskirkgraphics dot com | Date: | Mon, 07 Apr 2008 16:29:29 +0000 |
| Subject: | Re: Date comparison Question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-272664@lists.php.net to get a copy of this message | ||
Yes my mistake was looking at another record and published another.
But I figured it out now i can publish 1:45 like i wanted. Having a moment there.
Thank you
Richard L. Buskirk
On Mon, Apr 7, 2008 at 9:42 AM, <admin@buskirkgraphics.com> wrote:
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?
hmm.
different results for me w/ this code
<?php
$time1 = strtotime('2008-04-07 11:15:32');
$time2 = strtotime('2008-04-07 11:17:17');
echo "time1: $time1" . PHP_EOL;
echo "time2: $time2" . PHP_EOL;
$interval = $time2 - $time1;
echo $interval . PHP_EOL;
?>
time1: 1207588532
time2: 1207588637
105
-nathan