title: How to get 2 years prior date from currentdate using sql query
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/4366143/how-to-find-2-years-back-date">How to find 2 years back date</a>  </p>
  </blockquote>
  
  
  
  <p>I need to derive 2 years prior date of current date using a query in SQL Server 2008.</p>
  
  <p>For ex : today's date is <code>2012-11-27</code>. I need to get the date exactly 2 years before this date in the above format (<code>YYYY-MM-DD</code>).</p>
  
  <p>Please let me know if there are multiple approaches and which one would be better.</p>
  
  <p>Thanks &amp; Regards,
  Alex</p>