title: Round unix time stamps in Mysql query
body: <p>I have a table with two columns, an id, and a unix timestamp (i.e. not Mysql style, but just a pure seconds from 1970 type.)</p>
  
  <p>I want to know how many timestamps there are in each day.</p>
  
  <p>The query I have so far is:</p>
  
  <pre><code>SELECT unixtime, count(unixtime)
      AS count
      FROM core
      GROUP BY unixtime
  </code></pre>
  
  <p>What I need to do of course is to round the unixtime stamp up to the nearest day. How do I do this?</p>