try combining it with php

$now = date("Y-m-d H:i:s")

$sql = "select timediff($now, logouttime) from tblUserTracking";


From: Chuck Brockman <[EMAIL PROTECTED]>
Reply-To: Chuck Brockman <[EMAIL PROTECTED]>
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.


PHP Database Mailing List (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to