title: How to get DATE from DATETIME column?
body: <p>I want to get date from DateTime column.</p>
  
  <pre><code>&lt;asp:SqlDataSource ID="SqlDataSource1" runat="server" 
  ConnectionString="&lt;%$ ConnectionStrings:ConnectionString %&gt;" 
  SelectCommand="SELECT [name], [book_id], [book_name], [taken_date], [last_date], [renewed_date], [status], [comment], [fine_amount] FROM [library] WHERE ([admn_no] = @admn_no)"&gt;
  &lt;SelectParameters&gt;
     &lt;asp:ControlParameter ControlID="TextBox1" Name="admn_no" PropertyName="Text" 
     Type="String" /&gt;
  &lt;/SelectParameters&gt;
  &lt;/asp:SqlDataSource&gt;
  </code></pre>
  
  <p>From the above these 
  <code>[taken_date]</code>,<code>[last_date]</code>,<code>[renewed_date]</code> 
  columns showing date and time </p>
  
  <blockquote>
    <p>(eg: <code>4/14/2015 12:00:00 AM</code>).</p>
  </blockquote>
  
  <p>How do I display only date </p>
  
  <blockquote>
    <p>(eg: <code>4/14/2015</code>)?</p>
  </blockquote>