title: SQL Server select where datetimeoffset older than 1 hour
body: <p>I know this should be easy and I do it no probelms in mySQL and Postgresql but I'm struggling with SQL Server. I want to select rows with a datetimeoffset field that's over an hour old.</p>
  
  <pre><code>select * from table where mydatetime &lt; getdate() - 1 hour
  </code></pre>
  
  <p>I've tried dateadd and datediff but can't get it right.</p>