title: Format Hour in DB2?
body: <p>Is there any way to display db2 Hour function with AM and PM?</p>
  
  <pre><code>select hour(TIMESTAMP) from ORDERS with ur 
  </code></pre>
  
  <p>This will give out like 5,6,7 etc..</p>
  
  <p>But i want AM/PM after the Hour time.</p>
  
  <p>I'd like to Dislpay as 5AM,6AM,7AM. Is it possible in db2?</p>