August 2nd, 2004, 09:52 AM
|
|
Contributing User
|
|
Join Date: Apr 2004
Posts: 103
Time spent in forums: 15 m 58 sec
Reputation Power: 5
|
|
|
smalldatetime, group by date
Hi, I have a logData columnt that is smalldatetime format. The prolem I'm having is that I want to group by just date. but I don't know if thats possible. Because this is time associated with it, it doesn't group the results by just date when I put this statement.
SELECT COUNT(userId), logDate as pageViews from qcLogPage Group By logDate
Is it possible to do it just by date? Thanks...
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
