title: Querying datetime columns for 'Now' minus a certain amount of time?
body: <p>Is there a way in TSQL to query for rows where a datetime column's value is "now minus (a certain amount of time)" to select a time range?</p>
  
  <p>For example in MySQL I could build this predicate like:</p>
  
  <pre><code>(EndTime BETWEEN NOW() - INTERVAL 2 DAY AND NOW())
  </code></pre>
  
  <p>How can this be done in TSQL in SQL Server?</p>