title: T-SQL (date) - how to get value within one hour?
body: <p>I am looking for an optimal decision of how to get table values according to their date and time but within just ONE past hour.</p>
  
  <p>I mean something in this way (a pseudocode):</p>
  
  <pre><code> SELECT value FROM Table WHERE date BETWEEN getdate() AND getdate()-ONE_HOUR
  </code></pre>
  
  <p>For the purpose of this question <code>Table</code> has these columns:</p>
  
  <ul>
  <li><code>value</code></li>
  <li><code>date</code></li>
  </ul>
  
  <p>Any useful snippet is appreciated :)</p>