title: Converting Time Interval to actual time in AM PM in Oracle
body: <p>How can i convert the result of select statement of time interval field in respective time in Am/Pm format. 
  My Field is:</p>
  
  <pre><code>Interval Day(2) To Second(6)
  </code></pre>
  
  <p>I tried this:</p>
  
  <pre><code>select To_Char(Att_EntranceTime , 'HH:MI AM') From EMPLOYEEATTENDENCETABLE;
  </code></pre>
  
  <p>however this does not help me, i have also tried to add the basetime from systime to my interval field but that did not help.. can someone suggest me what to do?</p>