title: Compare UTC NOW to a date field, T-SQL
body: <p>I've a <code>datetime</code> field with value such as <code>2014-06-12 23:17:39.657</code></p>
  
  <p>I need to check if this date is greater of less then the current time in UTC. </p>
  
  <p>I tried this:</p>
  
  <pre><code>SELECT *
  FROM Table_Name
  WHERE expire_time &gt; GETUTCDATE()
  </code></pre>
  
  <p>This is code, a part of the stored procedure, and it is not working as expected. It is returning all the records, even there are few rows where Table.expire_time > UTCNOW.</p>
  
  <p>How can I retrieve all the record in the table where expire date is greater than the UTC time?</p>