group by for column of type date

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,

-- 
mac

real email-adress: mac clondiag com