title: How to truncate time part from date in linq query?
body: <p>Hi I am trying to write linq query to get some details from Sql table. I have created column and storing date and time both. while returning i want to ommit time part. May I know is this possible?</p>
  
  <pre><code>  List&lt;returnObject&gt; obj = new List&lt;returnObject&gt;();
  obj = (from c in objectDB.NCT_Project
    join user in objectDB.NCT_UserRegistration on c.adminUserId equals user.User_Id
    where c.adminUserId == userId
                         select new returnObject
                         {
                             id = c.project_Id,
                             key = c.key,
                             created = c.createdDate //currently returns datetime
                         }).ToList(); 
  </code></pre>
  
  <p>Any help would be appreciated. Thank you.</p>