title: Converting time into 12 hour format without the AM/PM
body: <p>I would like to pull the datetime data from MSSQL 2014 displaying only the 12 hour format and WITHOUT the AM/PM. I have tried everything suggested over the internet as follows:</p>
  
  <pre><code>time_adm = convert(varchar(15), CAST(hadmlog.admdate AS TIME), 100), --//2:30PM
  </code></pre>
  
  <p>I also tried the <code>format()</code> but it returns an error "Common language runtime (CLR) execution is not supported under lightweight pooling ... etc"</p>
  
  <pre><code>time_adm22 = FORMAT(CAST(hadmlog.admdate AS DATETIME),'hh:mm') --error
  </code></pre>