try this:
select * from table where TIME(time_field) < = 12
"Jack" <[EMAIL PROTECTED]> wrote in message
060101c10b0d$cd941940$[EMAIL PROTECTED]">news:060101c10b0d$cd941940$[EMAIL PROTECTED]...
Hi folks
I have a filed in data type "time" , how would I compare the value submited
from the form with the value in that filed, which is in format "11:00:00" ?
When I do this in query:
select * from table where time < = '12:00:00'; ( in order select all records
that have time before noon)
it keeps saying sql syntax error.
What should I do?
Jack
[EMAIL PROTECTED]
"Love your enemies, it will drive them nuts"
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
