Help! How to group by days and ignore the hours?　

[Roseanne Zhang]

Simplified TABLE (foreign_id, event, time)
How to count the events by each day and foreign_id, and ignore the hour, minute, second difference by using a SQL statement.
I tried many ways, and no luck yet. I think I can do it by using Java code. But I still believe there must be an elegant SQL way to do it...
Please help! Thanks in advance!

[Roseanne Zhang]

Found the solution:
Create a view by using to_char(time, 'yyyymmdd') first, then select from the view using group by.