title: Unable to convert date and varchar to date in Oracle db
body: <p>I have following query:</p>
  
  <pre><code>SELECT TO_DATE(date || ' ' || time, 'DD-MON-YY HH24:MI:SS' ) FROM table;
  </code></pre>
  
  <p><code>date</code> is <code>DATE</code></p>
  
  <p><code>time</code> is <code>VARCHAR2(4000 CHAR)</code></p>
  
  <p>After executing query I get <code>27-OCT-16</code> without time instead of <code>27-OCT-16 14:26:09</code>. </p>
  
  <p>Is there any solution?</p>