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
