>I'm trying to select records based on dates.
>I have a table with dates in the format 2001-04-08 and I'm using the query:
>SELECT name, description, date_time FROM events WHERE YEAR(date_time) = 2001
>AND MONTH(date_time) = 04 AND DAYOFMONTH(date_time) = 08

WHERE field_holding_date="2001-04-08" should work.



PHP Database 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]

Reply via email to