r [mailto:[EMAIL PROTECTED]]
: > Skickat: den 18 oktober 2001 14:47
: > Till: MySQL List
: > Ämne: Re: newbie - questions about timestamp(14)
: >
: > Thanks for your reply, I have tried using the query as you suggest,
: see
: > below:
: >
: > SELECT user_ip IF(TIME_TO_SEC(NOW())
Thanks for your reply, I have tried using the query as you suggest, see
below:
SELECT user_ip IF(TIME_TO_SEC(NOW()) - TIME_TO_SEC(log_time) < 300, 'true',
'false') FROM clinic_log
But this just gives me an error, ie the query won't run?
Does the query seem to be right?
Thanks again
Paul
-
