Re: date problems
| From: | Mike Gohlke | Date: | Thu, 06 Sep 2007 18:56:01 +0000 |
| Subject: | Re: date problems | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-43969@lists.php.net to get a copy of this message | ||
It's much better to use add_date instead of to_days since mysql isn't smart enough to do it for you.
Such as:
SELECT yourEventFields FROM theTable
WHERE theEventDate BETWEEN now() AND date_add(now(), INTERVAL 21 DAYS;
This way mysql will calc the now() and date_add and will essentially convert them to static values. If there's an index on theEventDate it will be used.
Mike...
Instruct ICC wrote:
From: rDubya <ryan.dubya@gmail.com> My problem is that I have events dated for Sep 2007 and on, and yet they all come up as being on Dec 7 to 9, 2006.. any ideas? rDubyaHow about having MySQL only return the events you are interested in? SELECT yourEventFields FROM theTable WHERE TO_DAYS( theEventDate ) >= TO_DAYS( NOW() ) AND TO_DAYS( theEventDate ) <= TO_DAYS( NOW() ) + 21 I like theEventDate to be in the format YYYY-MM-DD http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_to-days _________________________________________________________________ A place for moms to take a break! http://www.reallivemoms.com?ocid=TXT_TAGHM&loc=us