Re: group by for column of type date

Hi Michael,

try this :
... group by TO_CHAR(crea_date, 'YYYY-MM-DD')

..but it's not tested

Rgds

    Dirk
"Michael Howitz" <mhowitz_at_firemail.de> schrieb im Newsbeitrag news:3DDB4E71.7000809_at_firemail.de...
> 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
>
Received on Wed Nov 20 2002 - 03:21:15 CST