title: How to compare two DateTimes on Time only ignoring the date?
body: <p>Seems like everyone always ignores the time part, but how would you compare two datetimes ignoring the date? if we just compare them as TIME it seems to still favor the oldest date.</p>
  
  <p>(12/02/2004 9:00) > (12/02/2011 8:24) --this would be true.</p>
  
  <p>The below code works but it feels a bit a bit beating around the bush comparing the hours and minutes separately.</p>
  
  <pre><code>var results = from x in dataContext.GetTable&lt;ScheduleEntity&gt;()                           
                where x.LastRunDate &lt; date.Date 
                &amp;&amp; x.reportingTime.Hour &lt;= date.Hour
                &amp;&amp; x.reportingTime.Minute &lt;= date.Minute
                &amp;&amp; x.reportingFequency.Substring(position, 1) == scheduled
                select x;  
  </code></pre>
  
  <p>Also, the reason we are doing this is because we couldn't get our SQL TIME to compare to a TIMESPAN <a href="http://msdn.microsoft.com/en-us/library/ms131092.aspx?PHPSESSID=lm71lj7i6gj5fjtebtb2srl4n3" rel="noreferrer">this</a> says it would be the same but LINQ is returning a "TIME to bigint conversion error".</p>