title: How to display the date as mm/dd/yyyy hh:mm Am/PM using sql server 2008 r2?
body: <p>My sample query is </p>
  
  <pre><code>SELECT D30.SPGD30_LAST_TOUCH_Y
  from CSPGD30_TRACKING D30 
  </code></pre>
  
  <p>My given date format is like <code>"2013-01-01 00:00:00.000"</code>. I need to convert this date format to <code>"mm/dd/yyyy hh:mm AM/PM"</code>. Do you have any idea about that?</p>