title: Get datetime field in specific format
body: <pre><code>( SELECT CONVERT(VARCHAR(30),it.EndDate,101))[end]
  </code></pre>
  
  <p>will return date as <code>06/17/2013</code> and</p>
  
  <pre><code>(SELECT CONVERT(VARCHAR(30),it.StartDate) )[start] 
  </code></pre>
  
  <p>will return date as <code>Jun 17 2013  2:00PM</code> and I need date in the following format  <code>06/17/2013 2:00 PM("/" is important)</code> . Can you please help me on this</p>