Re: mySQL date query
| From: | Ron Piggott | Date: | Tue, 13 Apr 2010 06:31:09 +0000 |
| Subject: | Re: mySQL date query | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47047@lists.php.net to get a copy of this message | ||
It is in a 'date' column type YYYY-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.piggott@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
>> 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 seven full days.
>>
>> This is the beginning of the query. The date column is "date".
>>
>> SELECT count(
visits) as users FROM
>> stats WHERE date
>>
>> Thanks, Ron
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>