title: How to get short date format from the datetime object
body: <p>I am capturing the time in the text box (by using AJAX calender extender)
  the time in the string is <code>12/10/2013</code>, but when I assign the string to a datetime object it is converted into <code>12/10/2013 12:00:00 AM</code>.</p>
  
  <p>I want to use the date to filter the records in the database using the query below. Please help</p>
  
  <pre><code>string date1 = txtDate1.Text;
  
  DateTime date = DateTime.ParseExact(txtDate1.Text, "MM/dd/yyyy", 
  
   System.Globalization.CultureInfo.InvariantCulture);
   string strQuery = "SELECT Story.UserName,Story.StoryId,COUNT(Likes.StoryID) AS         NumberOfOrders 
   FROM Likes LEFT JOIN Story ON Likes.StoryId=Story.StoryId and liked=" + date1 + "
   GROUP BY Story.StoryId,Story.UserName order by NumberOfOrders DESC ;";
  </code></pre>