have a look at date_format in the mysql help and pull your sate filed out as
a date
Steve
> -----Original Message-----
> From: Jack [mailto:[EMAIL PROTECTED]]
> Sent: 12 July 2001 21:04
> To: [EMAIL PROTECTED]
> Subject: [PHP] time compare in my sql
>
>
> 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]