Re: group by for column of type date

SELECT TO_CHAR(crea_date, 'YYYY-MM-DD') crea_date,

        COUNT(*) crea_date_cnt
FROM cct_access
WHERE crea_date >= TO_DATE('2002-11-06 00:00:00', 'YYYY-MM-DD HH24:MI:SS') GROUP TO_CHAR(crea_date, 'YYYY-MM-DD');

?

Michael Howitz wrote:
> hello newsgroup!
>
> i have a table where i also stored the creation date of the row.
> now i want to select how many rows where created on each day.
>
> my current select string is:
>
> SELECT TO_CHAR(crea_date, 'YYYY-MM-DD') crea_date,
> COUNT(crea_date) crea_date_cnt
> FROM cct_access
> WHERE crea_date >= TO_DATE('2002-11-06 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
> GROUP BY crea_date;
>
> but it only groups the rows which are created at the same second but i
> want to group by the same day.
>
> the column crea_date is of type date and a have oracle 8.1.5, 8.1.7, 9.0
> and 9.2 (the solution should run on each of this versions).
>
> thanks in advance,
Received on Wed Nov 20 2002 - 03:15:51 CST