title: Extract time part from TimeStamp column in ORACLE
body: <p>Currently I'm using <code>MyTimeStampField-TRUNC(MyTimeStampField)</code> to extract the time part from a timestamp column in Oracle. </p>
  
  <pre><code>SELECT CURRENT_TIMESTAMP-TRUNC(CURRENT_TIMESTAMP) FROM DUAL
  </code></pre>
  
  <p>This returns</p>
  
  <blockquote>
    <p>+00 13:12:07.100729</p>
  </blockquote>
  
  <p>This works OK for me, to extract the time part from a timestamp field, but I'm wondering if there is a better way (may be using a built-in function of ORACLE) to do this?</p>