title: How to get time string to Time in oracle sql
body: <p>I have insert time in form of string in oracle VARCHAR2 column.   But when I try to retrieve it in form of time it's not giving me right time, it's only giving me a date which I have not saved.</p>
  
  <pre><code>INSERT INTO table1
      (timestr) Select substr(numtodsinterval(MAX(date1)-MIN(date2),'day'),
  12,8)  from table2 where ....; // stored timestr column value: 00:00:00
  </code></pre>
  
  <p>Retrieve ...</p>
  
  <pre><code>select TO_DATE(timestr,'hh24:mi:ss') from table1; 
  </code></pre>
  
  <p>... is only giving <code>10/01/2015</code></p>