title: How to compare two DateTimeOffSet?
body: <p>I have a variable which is of type DateTimeOffSet. I'd like to filter all the projectS that were created after January 1st, 2010.</p>
  
  <p>So I've wrote the following query:</p>
  
  <pre><code>   var _date = new DateTimeOffset(2010, 01, 01, 0, 0, 0, new TimeSpan(-7, 0, 0));
  
     var projects = _repository.Find&lt;Project&gt;
                   (x =&gt; x.CompanyId = CompId &amp;&amp; x.CreatedOn &gt; _date)
                  .ToList();
  </code></pre>
  
  <p>But when I look at the database, those are the type of values I see:</p>
  
  <pre><code>2001-01-25 05:21:46.4370000 -08:00
  2005-06-17 00:00:00.0000000 -07:00
  </code></pre>
  
  <p>Clearly, some of the values have <strong>-08:00</strong> and others have <strong>-07:00</strong>. So is my above query still relevant? When I look at the result, the filtering is being done the way I'm expecting it. The only concern is what the meaning of that offset part, maybe the result is good by accident. </p>
  
  <p>I'm not that familiar with the way <strong>DayeTimeOffSet</strong> works. </p>