title: Group by date without time in Firebird
body: <p>I want grouping sales in day-to-day from Firebird table.</p>
  
  <p>I have written SQL statement in this way.</p>
  
  <pre><code>SELECT CAST(STARTTIME AS DATE)
  FROM TESTTABLE
  GROUP BY CAST(STARTTIME AS DATE)
  </code></pre>
  
  <p>It is giving an error</p>
  
  <pre><code>Dynamic SQL Error SQL error code = -104 Token unknown - line 3, char 10 CAST 
  </code></pre>