RE: [PHP-DB] Timediff/Subtime questions
| From: | Bastien Koert | Date: | Tue, 26 Jul 2005 18:01:04 +0000 |
| Subject: | RE: [PHP-DB] Timediff/Subtime questions | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39978@lists.php.net to get a copy of this message | ||
try combining it with php
$now = date("Y-m-d H:i:s")
$sql = "select timediff($now, logouttime) from tblUserTracking";
Bastien
From: Chuck Brockman <cjbrockman@gmail.com> Reply-To: Chuck Brockman <cjbrockman@gmail.com> To: php-db@lists.php.net Subject: [PHP-DB] Timediff/Subtime questions Date: Tue, 26 Jul 2005 13:48:39 -0400 I've got a table that has a field logouttime which is a timestamp. I've tried using the timediff() function in mysql and get an error: select timediff(now(), logouttime) from tblUserTracking Each time it returns (err). However, if I used a query such as: select timediff('2005-07-26 22:00:00.0', '2005-07-26 20:00:00.0',) I get the appropriate return. I am running mysql 4.1.12. Can timediff() be used in such a manner as the first example? I've tried subtime but get NULL for return values. Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php