title: sql group by date without time
body: <p>I am new to sql, and I would like to create a query that will count all my article id's for each day. but the problem the date column is also containing time.. so how I can make the query to group by just by date without time? </p>
  
  <p>for example: </p>
  
  <pre><code>id|article_id|date (timestamp)
  
  1|22|2014-01-10 13:30:10 
  1|23|2014-02-10 12:30:10 
  </code></pre>
  
  <p>Thanks
  Shai</p>