Re: time compare in my sql
| From: | elias | Date: | Thu, 12 Jul 2001 10:13:33 +0000 |
| Subject: | Re: time compare in my sql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-57559@lists.php.net to get a copy of this message | ||
try this:
select * from table where TIME(time_field) < = 12
"Jack" <jacky@activelifestyle.com> wrote in message
news:060101c10b0d$cd941940$6400a8c0@activelifestyle.com...
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
jacky@activelifestyle.com
"Love your enemies, it will drive them nuts"