title: Date conversion
body: <p>I have a table with a datetime column  I want to retrieve the date in hh:mm:ss where hours is 12hour.</p>
  
  <p>I have tried the following.</p>
  
  <pre><code> convert(varchar(10), t2.CSM_START_TIME,108),
   convert(varchar(2),datepart(hour,t2.CSM_START_TIME))
      +':'+convert(varchar(2),datepart(mm,t2.CSM_START_TIME))
      +':'+convert(varchar(2), datepart(SECOND,t2.CSM_START_TIME))  
      as START_TIME
  </code></pre>