Re: group by for column of type date

Matthias Rogel wrote:
> 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');
>
> ?

yes! this was what i needed. thank you very much.

-- 
mac

real email-adress: mac clondiag com