title: How to search for a date in timestamp field?
body: <p>I have a database and a table with below attributes:</p>
  
  <pre><code>Column: Date 
  Type: TIMESTAMP 
  Attributes: ON UPDATE CURRENT_TIMESTAMP 
  Default: CURRENT_TIMESTAMP
  </code></pre>
  
  <p>So each data will showing up in this format: "2013-07-06 14:32:18" </p>
  
  <p>I'm looking for a SQL query that shows retrieves rows in "2013-07-06".</p>
  
  <p><strong>What I'm tried:</strong></p>
  
  <pre><code>select * from posts where date between "2013-07-05 00:00:00" and "2013-07-07 00:00:00";
  </code></pre>