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@xxxxxxxxx>
Reply-To: Chuck Brockman <cjbrockman@xxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
