title: SQL Output to get only last 7 days output while using convert on date
body: <p>I am using the below SQL Query to get the data from a table for the last 7 days.</p>
  
  <pre><code>SELECT * 
  FROM   emp 
  WHERE  date &gt;= (SELECT CONVERT (VARCHAR(10), Getdate() - 6, 101)) 
         AND date &lt;= (SELECT CONVERT (VARCHAR(10), Getdate(), 101)) 
  ORDER  BY date 
  </code></pre>
  
  <p>The data in the table is also holding the last year data.</p>
  
  <p>Problem is I am getting the output with Date column as </p>
  
  <pre><code>10/11/2013
  10/12/2012
  10/12/2013
  10/13/2012
  10/13/2013
  10/14/2012
  10/14/2013
  10/15/2012
  10/15/2013
  10/16/2012
  10/16/2013
  10/17/2012
  10/17/2013
  </code></pre>
  
  <p>I don't want the output of <code>2012</code> year. Please suggest on how to change the query to get the data for the last 7 days of this year.</p>