title: How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
body: <p>Is there a way to compare two <code>DateTime</code> variables in <code>Linq2Sql</code> but to disregard the Time part.</p>
  
  <p>The app stores items in the DB and adds a published date. I want to keep the exact time but still be able to pull by the date itself.</p>
  
  <p>I want to compare <code>12/3/89 12:43:34</code> and <code>12/3/89 11:22:12</code> and have it disregard the actual time of day so both of these are considered the same.</p>
  
  <p>I guess I can set all the times of day to <code>00:00:00</code> before I compare but I actually do want to know the time of day I just also want to be able to compare by date only.</p>
  
  <p>I found some code that has the same issue and they compare the year, month and day separately. Is there a better way to do this?</p>