If you want to group by the SELECT query using the date field for each day, it will consider the time with the date while grouping. For example the below query.select JOIN_DATE, count(*) from USER where STATUS = 0 group by JOIN_DATE;

To get the exact result for each day by eliminating the time, you need to truncate the time from the date field. You can use the trunc function of oracle to remove time part.select trunc(JOIN_DATE), count(*) from USER where STATUS = 0 group by trunc(JOIN_DATE);

Output will be13-Sep-2006, 414-Sep-2006, 3

This kind of feature is also available at later version of mysql. But I don't know what is the exact function and way to use. If anyone know, can post here.