List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:June 27 1999 10:46pm
Subject:Re: date problem
View as plain text  
>>>>> "Paul" == Paul DuBois <paul@stripped> writes:

Paul> At 6:31 AM -0700 6/24/99, Dan Parisien wrote:
>> I couldn't find a good enough example in the documentation,
>> I have a table with created_on date fields, I want to query created on fields
>> created in the last 5 days or something,
>> do I do curdate()+5 ??
>> Im not sure how,
>> thanks,
>> Dan P


Paul> Something like that, though you might want curdate()-5 instead. :-)

mysql> create table t (date date);
mysql> insert t values("1999-6-23"),(19990622),(19990620),(19990618);
mysql> select * from t;
Paul> +------------+
Paul> | date       |
Paul> +------------+
Paul> | 1999-06-23 |
Paul> | 1999-06-22 |
Paul> | 1999-06-20 |
Paul> | 1999-06-18 |
Paul> +------------+
mysql> select * from t where date < curdate()-5;
Paul> +------------+
Paul> | date       |
Paul> +------------+
Paul> | 1999-06-18 |
Paul> +------------+

The above is not correct (- doesn't work realiable with dates).

Use instead:

select * from t where date < DATE_SUB(curdate(),INTERVAL 5 days);

Regards,,
Monty

*************** Warning commercial signature follows **********
If you like TCX's concept of a 'mostly free' database and free
advice, you should at least CONSIDER supporting us that we can
afford to keep this service up.   http://www.mysql.com/
Thread
date problemDan Parisien24 Jun
  • Re: date problemPaul DuBois25 Jun
    • Re: date problemMichael Widenius28 Jun