title: Extract only date part in a datetimein LINQ
body: <p>We have some data in a <code>DataTable</code> and we are using the query like this to get what we need.</p>
  
  <pre><code>IEnumerable&lt;Results&gt; subResult = from query in datatable.AsEnumerable()
                               select new Results
                                    {
                                        Name = query.Field&lt;string&gt;("Name"),
                                        Date = query.Field&lt;DateTime?&gt;("Date")
                                    }
  </code></pre>
  
  <p>This above query returns what i need but date in full format (Ex:  <code>m/dd/yyyy hh:min:sec am/pm</code>) but we need only date part of it(only mm/dd/yyyy need to be pulled in). When looked in the properties of this, couldn't find an implicit way to get it, please help me in getting this result. Thanks.</p>