title: convert varchar field data in date format in oracle
body: <p>I have table test column has cretaed_dt and id.Both are varchar 2 type.</p>
  
  <p>desc test</p>
  
  <pre><code>ID Varchar2(30)
  Created_Dt varchar2(30)
  </code></pre>
  
  <p>select * from test</p>
  
  <pre><code>ID       created_dt
  1        2014-07-22-12.23.49.832868
  2        2014-08-04-19.40.11.787317
  3        2014-06-15-19.40.11.787317
  </code></pre>
  
  <p>I need to pick the data between 21st July to 5th aug 2014.Idealy ID 1 and 2 need to pick.</p>
  
  <p>I am not able to do this because created date column is in varchar2.</p>
  
  <p>Please assist.</p>