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

Reply via email to