title: SQL date format picture ends before converting entire input string
body: <p>I am trying to execute a query looking something like this:</p>
  
  <pre><code>create table A as    
  
  select 
      userid, to_date(date1, 'mm/dd/yyyy') as startDate, 
      to_date(date2, 'mm/dd/yyyy') as endDate
  from TABLE;
  </code></pre>
  
  <p>I am getting the error:</p>
  
  <blockquote>
    <p>ORA-01830: date format picture ends before converting entire input string</p>
  </blockquote>
  
  <p>What's really strange here is that when I run only the SELECT... part of the query it works perfectly, I am only getting the error when I try to create a table.  I absolutely need to make a table, so how can I get around this?</p>
  
  <p>Thanks!</p>