title: Datetime field using military time - need time only in standard time
body: <p>I have a datetime field in SQL Server 2008 which stores the date and time in military format (or international format if you prefer)</p>
  
  <p>examples: </p>
  
  <pre><code>2011-02-15 10:00:00.000
  2011-02-15 15:30:00.000
  2011-02-15 17:30:00.000
  </code></pre>
  
  <p>I need to retrieve the time only portion of this in standard U.S. time format.</p>
  
  <p>So  </p>
  
  <pre><code>2011-02-15 10:00:00.000    needs to become 10:00 AM
  2011-02-15 15:30:00.000    needs to become 3:30 PM
  2011-02-15 17:30:00.000    needs to become 5:30 PM
  </code></pre>
  
  <p>I am looking for the best way to accomplish this in T-SQL please.</p>