title: sort table with timestamp field without considering time of day
body: <p>I have a table in Mysql (firstname,lastname,data1,data2,...) that one field name is <strong>MYDATE</strong> and  type of this field is <code>timestamp</code>.  In this field, the date saved  as (yyyy-mm-dd mm:ss:ms), and there are many records of this table.</p>
  
  <p>I want write a <strong>select query</strong> that sort this table with (yyyy-mm-dd) and without considering (mm:ss:ms).</p>