RE: [PHP] time compare in my sql
| From: | Steve Brett | Date: | Thu, 12 Jul 2001 10:30:28 +0000 |
| Subject: | RE: [PHP] time compare in my sql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-57563@lists.php.net to get a copy of this message | ||
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:jacky@activelifestyle.com]
> Sent: 12 July 2001 21:04
> To: php-general@lists.php.net
> 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
> jacky@activelifestyle.com
> "Love your enemies, it will drive them nuts"
>