title: using sql query with group by date
body: <p>I'm trying to write this query to retrieve No. of records grouped by date:</p>
  
  <pre><code>SELECT system_date,count (is_paid)
    FROM TPWEB.TP_CLIENT_TENDER_TRANS
    where system_date between '1-DEC-12' and '31-DEC-12'
    group by system_date
  </code></pre>
  
  <p>But, I got result without grouping such as:</p>
  
  <pre><code>01-DEC-12   1
  01-DEC-12   1
  01-DEC-12   1
  01-DEC-12   1
  </code></pre>
  
  <p>what is wrong...</p>