title: Compare Two different formats of the DateTime
body: <p>I have <code>EndDate</code> column in my table which accepts records like this </p>
  
  <p><b>2014-10-29 00:00:00.000</b></p>
  
  <p>Now I want to compare this <code>DateTime</code> with <b>present date</b> . For that , I did like this :- </p>
  
  <pre><code> var today=DateTime.Now;
  
   var LstEvents = (from t in _context.Tournaments
                               where t.SiteId == siteId &amp;&amp; t.EndDate != null
                               &amp;&amp; t.EndDate &lt; today
                               select t).ToList();
  </code></pre>
  
  <p>But <code>t.EndDate &lt; today</code> is not returning results as I wanted . I did <b>Add Watch</b> for today and checked the value and it's format was like </p>
  
  <p><b>today    {11/3/2014 8:12:00 PM}  System.DateTime</b></p>
  
  <p>Therefore my dates are unable to be compared . 
  Any help would be much appreciated </p>
  
  <p>Thanks !!</p>