title: Extract only date from a DateTime column asp.net
body: <p>in the SqlDataSource, I have specified a SelectCommand that retrieves a date:</p>
  
  <pre><code>SelectCommand="SELECT [training_id], Convert(varchar(14),[trainingDate],101) FROM [tbl_training]"
  </code></pre>
  
  <p>However DateGenerated gives me a value like 11/04/2011 12:00:00 AM. How do I extract only 11/25/2011 using SelectCommand?</p>
  
  <p>Any help would be appreciated.</p>