fetch date from datetime column in sql
<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>