title: Convert 24 hr format to 12 hr AM/PM format in SQL query
body: <p>I know there are several questions similar to mine, but I need specifics. Using SQL in Microsoft Query, I have a time column that produces a result like <code>1900-01-01 13:30:00:0000000</code> and I need to convert it to produce only a <code>1:30PM</code> result. </p>
  
  <p>Now, my column is <code>ODS_COURSE_SECTION_MTG.CSM_START_TIME</code> so I need to know, when I'm in "Edit Column" where and exactly what in the "Field" to type.</p>
  
  <p>I have done </p>
  
  <pre><code>CONVERT(TIME, ODS_COURSE_SECTION_MTG.CSM_START_TIME)
  </code></pre>
  
  <p>but that only produces a <code>13:30:00:0000000</code> result.</p>
  
  <p>Please help! Please tell me exactly how to edit that column to get the <code>1:30PM</code> result. </p>
  
  <p>Thank you in advance!</p>