Try this: SELECT a, b FROM tblName WHERE TO_DAYS(NOW()) - TO_DAYS(pubDate) <= 7;
Anthony > What is the proper query for slect all from the past > number of days. > > i.e. I would like to return all articles from the past > week. Right now I am using SELECT blah, bla FROM table > WHERE pubDate BETWEEN CURDATE() - 7 AND CURDATE() AND > whatever = 'whatever' > > This worked fine until today. the first of month. > > Thanks much, > olinux > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Health - your guide to health and wellness > http://health.yahoo.com > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Anthony W. Marino Pres./CTO, AWM Objects email: [EMAIL PROTECTED] phone: (732) 610-2441 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php