title: How to display Date in DD/MM/YYYY H:MM AM/PM format in SQL Server
body: <p>I have a DATETIME Column in a table and I need to show the date in the 
  following format "DD/MM/YYYY H:MM AM/PM" </p>
  
  <pre><code>CreatedBy
  2013-07-30 12:44:06.000
  2013-07-30 12:45:57.000
  2013-08-05 16:51:26.000
  2013-08-05 19:08:18.000
  2013-08-05 19:11:46.000
  2013-09-12 12:44:27.000
  </code></pre>
  
  <p>I need the date like this--> <code>"30/07/2013 12.44 PM"</code></p>