title: Extract hour from timestamp in 12 hour format with AM/PM indicator oracle
body: <p>I'm trying to extract hour from time-stamp column (oracle)  in 12 hour format with A.M/P.M indicator.</p>
  
  <p>The column "subdate" has value  22-APR-20 04.18.40.000000000 PM</p>
  
  <p>The Extract(HOUR from subdate) function returns</p>
  
  <p>16</p>
  
  <p>However, I want the value to be 4.00 PM</p>
  
  <p>I have tried various options with the trunc and to_char functions but none of them gave the desired output. </p>
  
  <p>Can you please help with this!</p>
  
  <p>Thank you!</p>