title: why the sql commands Interval is used for?
body: <p>I wrote the following code in model with sql commands interval etc.</p>
  
  <pre><code>$i= $this-&gt;db-&gt;where('DATE_ADD(asl.search_run_date,INTERVAL 2 DAY) &gt;', 'NOW()', FALSE); 
  </code></pre>
  
  <p>I thought that <code>$i</code> consists of the records that are 2 days before the present date......i am i correct?why false is used in the above step?</p>
  
  <p>Does the following step also does the same as above?</p>
  
  <pre><code>$where="(datediff(now(),asl.search_run_date) &gt;= 1)";
  </code></pre>
  
  <p>Can someone explain it?</p>