Timediff/Subtime questions
| From: | Chuck Brockman | Date: | Tue, 26 Jul 2005 17:48:39 +0000 |
| Subject: | Timediff/Subtime questions | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-39976@lists.php.net to get a copy of this message | ||
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