working with daily results : results per day

External Since: Mar 22, 2005 Posts: 1

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?

External Since: Dec 07, 2004 Posts: 587

Try building a Calendar table with the start and end times for each
day. You can add other information, like holidays, quarters, fiscal
years, etc, Using functions is proprietary and slow.

You also ought to look at ISO-11179 so you will stop putting "tbl-" and
"dt-" prefixes on your data elements.