Thanks, the query is now working, butit is not producing the required
results. I have now tried many different methods, it does not seem to me to
be possible to compare these times!!
Thanks anyway
Paul
- Original Message -
From: "Torgil Zechel" <[EMAIL PROTECTED]>
Make it a text column, this has an allowable length of 0-65535 ..
HTH
Paul
- Original Message -
From: "Purcell, Scott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 18, 2001 2:12 PM
Subject: Large Memo Type Field
: Hello,
: I am working on a school project and
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
-
Hi all
I'm having a problem getting a query to work where I want to compare the
current_timestamp to the logged timestamp, and return false if less than 300
seconds, can you tell me if it is possible to have the current timestamp
returned as part of a query, so as I can then do my calculations in
