Mysql datetime type

[wuno]

Hello:

I have got a table with datetime record in it. The record has got a column name 'cdate' and it's type is MySQL datetime format.

When I want to retrieve the record which date is greater than '2005-05-16', I used a query like "SELECT * FROM orders WHERE cdate >= 2005-05-16".

It didn't work at all. How can I re-write the query to get it work?

Thanks.

Norman

[drew010]

a query like that should work fine, make sure you enclose your date inside single quotes...this sample is pulled from the mysql site.
mysql> SELECT * FROM tbl_name WHERE date >= '2003-05-05';