title: How to get one day ahead of a given date?
body: <p>Suppose I have a date 2010-07-29. Now I would like to check the result of one day ahead. how to do that</p>
  
  <p>For example,</p>
  
  <pre><code>SELECT * 
    from table 
   where date = date("2010-07-29")
  </code></pre>
  
  <p>How to do one day before without changing the string "2010-07-29"?</p>
  
  <p>I searched and get some suggestion from web and I tried </p>
  
  <pre><code>SELECT * 
    from table 
   where date = (date("2010-07-29") - 1 Day)
  </code></pre>
  
  <p>but failed.</p>