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?

[Back to original message]