Re: Selecting Dates
| From: | B. van Ouwerkerk | Date: | Sun, 08 Apr 2001 10:13:53 +0000 |
| Subject: | Re: Selecting Dates | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-8356@lists.php.net to get a copy of this message | ||
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) = 08WHERE field_holding_date="2001-04-08" should work. Bye, B.