title: Getting incorrect date format when retrieving data from SQL in asp.net
body: <p>I have a database which has date field and time field. I want to retrieve these two values from the DB and display them in a <code>Label</code>. I could do this by binding an <code>SqlDataSource</code> with the DB and using <code>Eval</code> in the <code>label</code>, but the problem is that I always get an extra 12:00:00 am when retrieving the date. For example if the date is 13/11/2015, when I retrieve it via asp.net I get, 13/11/2015 12:00:00 am. </p>
  
  <p>I have executed a query in SQL itself and the results where correct with no 12:00:00 am. Also, when I configured the 'SqlDataSource' I clicked <code>Test Query</code> and the results were correct. </p>
  
  <p>I couldn't figure out why I'm getting incorrect format when displaying it in a label. The label is placed inside a <code>repeater ItemTemplate</code>. All other retrived data from the DB are retrieved correctly from inside the repeater except date. Here is the code which places the date in the Label, </p>
  
  <pre><code>&lt;span class="date_time_lbl"&gt;posted at: &lt;/span&gt;
  &lt;asp:Label runat="server" Text='&lt;%#Eval("tDate") %&gt;'/&gt;
  &lt;span&gt; &lt;/span&gt;
  &lt;asp:Label runat="server" Text='&lt;%#Eval("Time") %&gt;'/&gt;
  </code></pre>
  
  <p>Can anyone please tell me what is causing this problem? </p>