try this
SELECT DATE_ADD('2008-01-02', INTERVAL -7 DAY);
Chaitanya
On Tue, Apr 13, 2010 at 12:01 PM, Ron Piggott <
ron.pigg...@actsministries.org> wrote:
> It is in a 'date' column type -MM-DD
>
> > what is the format of the date u are storing ?
> >
> > Chaitanya
> >
> >
> >
> > On Tue,
It is in a 'date' column type -MM-DD
> what is the format of the date u are storing ?
>
> Chaitanya
>
>
>
> On Tue, Apr 13, 2010 at 11:50 AM, Ron Piggott <
> ron.pigg...@actsministries.org> wrote:
>
>> I am trying to write a mySQL query on my "stats" table. I am trying to
>> determine the num
Ron Piggott wrote:
I am trying to write a mySQL query on my "stats" table. I am trying to
determine the number of records (users) during a 7 day period ending
yesterday. I always to keep it current ... Yesterday will keep changing.
In other words I want to know the number of users who accessed
what is the format of the date u are storing ?
Chaitanya
On Tue, Apr 13, 2010 at 11:50 AM, Ron Piggott <
ron.pigg...@actsministries.org> wrote:
> I am trying to write a mySQL query on my "stats" table. I am trying to
> determine the number of records (users) during a 7 day period ending
> yes
I am trying to write a mySQL query on my "stats" table. I am trying to
determine the number of records (users) during a 7 day period ending
yesterday. I always to keep it current ... Yesterday will keep changing.
In other words I want to know the number of users who accessed the web
site during