title: Convert VARCHAR to Time in oracle
body: <p>I am using <code>ORACLE</code> and I want to convert <code>VARCHAR</code> type into Time using following SQL Query</p>
  
  <pre><code>SELECT CUSTOMER_SERVICE_QUOTE_MEAS.ITEM_CREATE_TM,
  TO_char(
  CUSTOMER_SERVICE_QUOTE_MEAS.ITEM_CREATE_TM,
  'hh24:mi:ss')
  AS TIME_CHANGE
  FROM FDC.CUSTOMER_SERVICE_QUOTE_MEAS CUSTOMER_SERVICE_QUOTE_MEAS
  </code></pre>
  
  <p>This results in <code>6/1/2013 11:32:02 AM</code> but I don't want the date part here.<br> I need only time portion <code>11:32:02</code>, How it can be done ?</p>
  
  <p>The field <code>CUSTOMER_SERVICE_QUOTE_MEAS.ITEM_CREATE_TM</code> has the data which look like this <code>113202</code>.
  Any help will be appreciated, Thanks.</p>