date format in sql query result
<p>I am trying to change the format in the result view for column name GroupingDate.
The current result is <code>2016-01-01 00:00:00</code>.</p>

<p>I want to see result like this,
<code>1/1/2016</code></p>

<p>current query is</p>

<pre><code>select GroupingDate, SEQ, SentAsReprint
from tproduction
where jobnumber = '111000_01'
</code></pre>