title: Oracle Get only time from To_Date() in a Query?
body: <p>I have an insert query:</p>
  
  <pre><code>INSERT INTO THE_TABLE (Field_A) 
  VALUES (TO_DATE('08/12/2011 08:35:42 AM','HH:MI:SS PM'))
  WHERE Something = 'SomethingElse'
  </code></pre>
  
  <p>Field_A is a Date field. When I execute the query, Field_A still shows a date and time. </p>
  
  <p>Is there a way to grab only the time?</p>
  
  <p>I have tried To_Char(), but then it converts to a string and the field wont take it. </p>
  
  <p>I have also tried TO_DATE('08:35:42 AM','HH:MI:SS PM') and that doesn't work either, it still shows a date and time in the table.</p>