title: Sqlite get only date from MM/dd/yyyy HH:mm:ss format
body: <p>I have stored my date and time in database in following format and as TEXT.</p>
  
  <blockquote>
    <p>MM/dd/yyyy HH:mm:ss</p>
  </blockquote>
  
  <p>I am trying to select <strong>all</strong> records ONLY from yesterday by doing this:</p>
  
  <pre><code>SELECT * from source_tbl where date_time = (select max(date_time) 
     from source_tbl 
     WHERE date_time &lt; DATE('now', '-1 day') )
  </code></pre>
  
  <p>I know that if I only store <strong>MM/dd/yyyy</strong> in database, then my above query will work fine, but in my situation I have <strong>HH:mm:ss</strong> so it is not going to work.</p>
  
  <p>But is there any way to get only <strong>MM/dd/yyyy</strong> portion and then apply my above query, or any way of doing this?</p>