title: Get time only of datetime
body: <p>I have datetime variable <code>officeStartTime</code> which hold datetime value as </p>
  
  <p><code>officeStartTime = {9/24/2013 10:00:00 AM}</code> </p>
  
  <p>and I have module <code>CHECKINOUT</code> which contain <code>userid</code>, <code>checktime</code> and other properties. </p>
  
  <p>Now what I want is to get list of <code>CHECKINOUT</code> entries whose time part of checktime is greater than time part of <code>officeStartTime</code>. </p>
  
  <p>I try:</p>
  
  <p><code>var checklist= con.CHECKINOUTs.Where(x =&gt; x.CHECKTIME.TimeOfDay &gt; officeStartTime.TimeOfDay);</code></p>
  
  <p><code>checklist</code> contains the following error is shown:</p>
  
  <p><code>{"The specified type member 'TimeOfDay' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported."}</code> . </p>
  
  <p>It says <code>TimeOfDay</code> is not supported in LINQ to Entities, if so how can I check for time part of datetime in LINQ. Is there any other way to do this? Please suggest me what to do. </p>
  
  <p>Thank you. </p>