title: Importing from csv to Oracle timestamp
body: <p>I have a column in a csv file called <code>created</code> with values:</p>
  
  <pre><code>2012-04-16 14:46:42
  2012-06-16 12:40:52.653000000
  </code></pre>
  
  <p>I am trying to import this into Oracle 11gR2 with SQL Developer 3.1.07</p>
  
  <p>I am using this as a format: <code>RRRR-MM-DD HH24:MI:SS.FF</code></p>
  
  <p>I get error <code>input value not long enough for the date format</code></p>
  
  <p>If I change the format to <code>RRRR-MM-DD HH24:MI:SS</code> I get error <code>SQL Error: ORA-01830: date format picture ends before converting entire input string</code></p>
  
  <p>How should I do it?</p>