title: SQL Counting Rows Per Day - Firebird Database
body: <p>I am using a Firebird database to store Logs from an Web App.
  Each logged step,is stored in a different row of this table.
  Each Row have a Data (OADATE formatted,as a double).</p>
  
  <p>My next step,is writing a report query,to select how many Logs were added per day.</p>
  
  <p>My Question is : How do i make this query?</p>
  
  <p>Just to clarify, my expected result would be something like this:</p>
  
  <pre><code>1-dec-2011 : 3 
  2-dec-2011 : 1
  5-dec-2011 : 8
  </code></pre>
  
  <p>And so on...
  How do i do that? </p>
  
  <p>I Just Tried :</p>
  
  <pre><code>select (extract (WeekDay from (cast (A.DATETIME as Date))))
  from EVENTSGENERAL A
  </code></pre>
  
  <p>Also,tried to cast as Timestamp,but the convertion from double to Date or Timestamp is giving me errors.</p>
  
  <p>Thanks in advance,let me know if you need any other information provided</p>
  
  <p>===========================================</p>