title: SQL datetime format to date only
body: <p>I am trying to select the DeliveryDate from sql database as just date. In the database, i am saving it as datetime format. How is it possible to get just date??</p>
  
  <pre><code>SELECT Subject, DeliveryDate 
  from Email_Administration 
  where MerchantId =@ MerchantID
  </code></pre>
  
  <p>03/06/2011 12:00:00 Am just be selected as 03/06/2011..</p>
  
  <p>Thanks  alot in advance! :)</p>