title: subtract date from sql column
body: <p>need ur help again</p>
  
  <p>i have a sql table with column <code>docid</code>,<code>proposedcompletiondate</code>,<code>docstatus</code></p>
  
  <pre><code>doc_id     ProposedCompdate    Docstatus
  0001         2011-10-30           A
  0002         2011-11-29           C
  0003         2011-10-31           C
  0004         2011-10-30           A
  0005         2011-10-30           C
  0006         2011-10-28           C
  0007         2011-10-25           A
  0008         2011-10-30           C
  </code></pre>
  
  <p>Now i want to write a query to fetch results with <code>Docstatus</code> <code>'A'</code> whose date when subtracted by 9 days should be current date</p>
  
  <p>for eg if todays Date is '21-10-2011'</p>
  
  <p>the resultset must be </p>
  
  <pre><code>doc_id     ProposedCompdate    Docstatus
  0001         2011-10-30           A
  0004         2011-10-30           A
  </code></pre>