title: "group by day" in Oracle doesn't appear to group by date
body: <p>My query looks something like this:</p>
  
  <pre><code>select datesent, count(*) the_count from receivedmessaged where status=5000
  and datesent&gt;(to_date('20130101', 'YYYYMMDD')) group by datesent
  </code></pre>
  
  <p>What I'm looking for is a table that has the count of messages with a status of 5000 per day, newer than a certain date. What I'm getting is a table with the same dates over and over. What I think is happening is that there is a hidden time part in that datesent field, and its grouping the entries by the exact time they were sent, rather than just looking at the date. Can anyone confirm this and tell me how I can fix it? Thanks!</p>