title: How to extract only Time from a DateTime field in Oracle SQL Developer?
body: <p>I tried <code>To_Timestamp</code> and other methods for SQL Developer but only this one worked fine for me.</p>
  
  <pre><code>Select To_Number(To_Char(DateTime_FieldName, 'HH24'))
      || ':' || to_number(to_char(DateTime_FieldName, 'MI'))
      || ':' ||to_number(to_char(DateTime_FieldName, 'SS'))
  from TABLE_NAME
  </code></pre>
  
  <p>Is there a better solution to this?</p>