title: select query using getdate() to after 15 days in sql server?
body: <pre><code>name   amount  date
  ---------------------------------------
  xxx     1000   2014-04-20 12:53:23.983
  yyy     1500   2014-04-25 12:53:23.983
  </code></pre>
  
  <p>My output like this:</p>
  
  <pre><code>name  amount  date
  --------------------------------------
  xxx     1000  2014-04-20 12:53:23.983
  </code></pre>
  
  <p>My query:</p>
  
  <pre><code>alter proc K_VM_GetTaxdetails
  as
  begin
     select name, amount, date 
     from K_VM_TaxDetails
     where DATEADD(day, -15, GETDATE()) = date 
  end 
  </code></pre>
  
  <p>I have tried like this but I am not getting required output.</p>
  
  <p>If I have a date = 2014-04-20 12:53:23.983 in my table, I want to display all data before 15 days from that date.</p>
  
  <p>How can I write in where condition?</p>