title: Firebird select Different Days from DateTime Column
body: <p>I am writing a Log Viewer,that will be able to show logs between two dates.
  Currently, i am using a:</p>
  
  <pre><code>SELECT DISTINCT DATETIME FROM EVENTSGENERAL A JOIN EVENTSGENERATORS B ON B.GENERATOR_ =    A.GENERATOR_ ;
  </code></pre>
  
  <p>But it returns too many values of each day for example,since the precision of OADATE used,is set to Miliseconds.</p>
  
  <p>How do i select Only One Value per Day?
  For example,if there are 100 rows of logs for <strong>day 1/January, Zero rows for days 2/January,3/January and 4/January, but 50 rows for day 5/January</strong> , how do i select : <strong>1/January,5/January ?</strong></p>
  
  <p>I am using a firebird database,and C# / ASP.NET </p>
  
  <p>Thanks in advance for any replies,and sorry about any bad english mistake </p>