<pre><code class="lang-sql">select trunc(DATE_ADDED),count(*) from RESULTS
where MERCHANT_ID='test123'
group by trunc(DATE_ADDED);
</code></pre>

```sql
select trunc(DATE_ADDED),count(*) from RESULTS
where MERCHANT_ID='test123'
group by  trunc(DATE_ADDED);
```

SQL : group results only by date and not date time