title: how to get data using date on my time stamp in SQL
body: <p>My field name <code>time</code> and datatype is <code>timestamp</code>  </p>
  
  <pre><code>SELECT
      *
  FROM
      order_table
  WHERE
      DATE(`time`) AS date_part = '2016-11-30';
  </code></pre>