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 functionJerry Swanson17 Feb
  • Re: UNIX_TIMESTAMP functionMichael Dykman17 Feb
    • Newbie:number of hits per day queryGraham Anderson7 May
      • Re: Newbie:number of hits per day queryAnoop kumar V7 May
        • Re: Newbie:number of hits per day queryAnoop kumar V7 May