|
|
Posted by rapataa on 08/05/05 13:29
Hi,
I'm trying to get an overview of counted visits per day for a
webapplication.
The thing is that SQL doesn't work with full days. For instance: getdate()
returns a fulldate instead of a date in the format 'yyyy-mm-dd'. I need this
format, without time specifics, to be able to group rows.
something like:
SELECT count(id), dtVisit
FROM tblName
GROUP BY dtVisit
and I would like to be able to show the results per day for an x amount of
(full) days.
anyone any idea?
Navigation:
[Reply to this message]
|