mySQL date query
in [Databases]
|
Prev: Postgres - how to skip 'sequence' columns
Next: "Fatal error: Call to undefined function pq_query()"
From: "Ron Piggott" on 13 Apr 2010 02:20 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
From: Chaitanya Yanamadala on 13 Apr 2010 02:24 what is the format of the date u are storing ? Chaitanya On Tue, Apr 13, 2010 at 11:50 AM, Ron Piggott < ron.piggott(a)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 > >
From: Chris on 13 Apr 2010 02:25 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 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` The mysql manual is a good place to start. http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-sub -- Postgresql & php tutorials http://www.designmagick.com/
From: "Ron Piggott" on 13 Apr 2010 02:31 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(a)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 >> >> >
From: Chaitanya Yanamadala on 13 Apr 2010 02:37
try this SELECT DATE_ADD('2008-01-02', INTERVAL -7 DAY); Chaitanya On Tue, Apr 13, 2010 at 12:01 PM, Ron Piggott < ron.piggott(a)actsministries.org> wrote: > 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(a)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 > >> > >> > > > > > |