title: Oracle - How to Convert VARCHAR to DATETIME format
body: <p>I am using <code>Oracle10g</code> database in which a table contains a Column with <code>Date</code> DataType. I am using the following query to get the record:</p>
  
  <pre><code> select to_char(START_TIME, 'YYMMDD HH24:MI:SS') from table;
  </code></pre>
  
  <p>So from above query, the result will be of type <code>VARCHAR</code>. I have tried <code>to_Date()</code> method but resulted in displaying only <code>DATE</code>. Can i convert <code>VARCHAR</code> to <code>DATETIME</code> format? The result should be of type <code>DATETIME</code>. Please help me how to resolve this problem.</p>