Need to count records and group count by date on oracle db using sql developer

oracle count oracle10g group-by oracle-sqldeveloper

I managed to get this results with this query:

select trunc(created), count(*)from table1group by trunc(created)

Note the trunc function, even if you don't display it, the DATE datatype holds the time as well

Here is a fiddle

CodeHunter