Re: Re: Selecting Dates
| From: | Jordan Elver | Date: | Sun, 08 Apr 2001 11:20:06 +0000 |
| Subject: | Re: Re: Selecting Dates | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-47641@lists.php.net to get a copy of this message | ||
That's what I thought but that doesn't work either?
On Sunday 08 April 2001 10:13, you wrote:
> >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.
>
> Bye,
>
>
> B.