title: How to get time part from SQL Server 2005 datetime in 'HH:mm tt' format
body: <p>How to get time part from SQL Server 2005 datetime in <code>HH:mm tt</code> format </p>
  
  <p>E.g. </p>
  
  <pre><code>11:25 AM
  14:36 PM
  </code></pre>