title: Select query to display Date format as mmm dd yyyy hh:mm am in SQL server 2008
body: <p>I tried like this</p>
  
  <p>select CONVERT(VARCHAR(20),GETDATE(),100)</p>
  
  <p>result is </p>
  
  <pre>
  ____________________
  Jun 12 2014  3:10PM
  ____________________
  </pre>
  
  <p>I need space between time {3:10PM}</p>
  
  <p>SELECT QUERY TO DISPLAY DATE AS SHOWN BELOW</p>
  
  <pre>
  ____________________
  Jun 12 2014  3:10 PM
  ____________________
  </pre>