title: Select where date without time
body: <p>I am using SQLite, now how can I Select a query if I have a timestamp column that has this value for example <code>07:00 06/03/13</code> but I want only to select where timestamp <code>06/03/13</code>.</p>
  
  <p>This is my example of my query..</p>
  
  <pre><code>select 
      timestamp, pname 
  from 
      attendance 
  where 
      timestamp between `06/01/13` and `06/10/13`
  </code></pre>