title: fetch date from datetime column in sql
body: <p>I have a Product table.I want fetch date from datetime column.
  I wrote this query.</p>
  
  <p>Query code is here</p>
  
  <pre><code>SELECT Date = CONVERT(DATE, Date) FROM Product
  </code></pre>
  
  <p>Query is running sql server management studio and returning the correct date but when called from C# the query runs and returns a result but it returns datetime rather than just the date.</p>
  
  <p>So for example if the query:</p>
  
  <pre><code>SELECT Date = CONVERT(DATE, Date) FROM Product
  </code></pre>
  
  <p>returns 09-02-16 in management studio </p>
  
  <p>the C# code </p>
  
  <pre><code>SqlDataAdapter adr;
          adr = new SqlDataAdapter("SELECT Date = CONVERT(DATE, Date) FROM Product", conn);
  </code></pre>
  
  <p>returns 09.02.2016 00:00:00</p>
  
  <p>What I would like the C# code to return is: 09-02-16</p>
  
  <p>Please help.</p>