| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Graham Anderson | Date: | May 7 2005 12:14am |
| Subject: | Newbie:number of hits per day query | ||
| View as plain text | |||
how do I get the average number of hits per day I have a table like: DateTime id ip 20050506190723 1 121.198.262 what I have so far SELECT DateTime , count( * ) FROM userLog GROUP BY DateTime LIMIT 0 , 30 I assume that DateTime would have to be converted to a specific day like 2005-3-7 and somehow I would need to average them can a kind soul point me in the right direction g
| Thread | ||
|---|---|---|
| • UNIX_TIMESTAMP function | Jerry Swanson | 17 Feb |
| • Re: UNIX_TIMESTAMP function | Michael Dykman | 17 Feb |
| • Newbie:number of hits per day query | Graham Anderson | 7 May |
| • Re: Newbie:number of hits per day query | Anoop kumar V | 7 May |
| • Re: Newbie:number of hits per day query | Anoop kumar V | 7 May |
