The other way to do this is with the DATE_ADD function: select [columns] where [date column] > DATE_ADD(NOW(), INTERVAL -7 DAY)
--jeff ----- Original Message ----- From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, April 07, 2002 10:29 AM Subject: Re: SQL Question... > Thanks, My book that I have been studying from, only show commands and no > examples. MySQL web had want I wanted at the very top. > > I have finish my page now. > > Chuck > > on 4/6/02 11:46 PM, Georg Richter at [EMAIL PROTECTED] wrote: > > > On Sunday, 7. April 2002 05:56, Chuck \"PUP\" Payne wrote: > > Hi, > >> > >> I am trying to set up a SQL statement using NOW(), what I am wanting to do > >> is to use NOW() then do a search on any date less than 7 days. Before I get > >> several e-mails asking why. I am trying to a news base database for the > >> company intranet and I am wanting to only show newsitems that are 7 days or > >> less. And I want NOW() to set today date and then go back as far as seven > >> days. But I am not sure now to use < less than in my statement with NOW(), > >> or if it will work. > >> > > > > http://www.mysql.com/doc/D/a/Date_and_time_functions.html > > There is a sample how to use TO_DAYS function. > > > > Regards > > > > Georg > > > > > > --------------------------------------------------------------------- > > 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 > > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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