title: How to convert the raw date into standard date format in Oracle database
body: <p>In Oracle I have date in the format like 2018-06-02T17:31:55.461Z  in varchar field. How do i convert this to standard date field in Oracle db? </p>
  
  <pre><code>create table testmp1
  (raw_date varchar2(4000));
  
  insert into testmp1
  (raw_date) 
  values ('2018-06-02T17:31:55.461Z');
  
  insert into testmp1
  (raw_date) 
  values ('2018-06-02T17:32:48.042Z');
  
  insert into testmp1
  (raw_date) 
  values ('2015-04-29T19:51:30.0Z');
  
  commit; 
  
  create table testmp2
  (new_date date);
  </code></pre>