RE: [PHP] time compare in my sql

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

[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