title: SQL Loader date format
body: <p>Hi i am trying to load data from a file into a table in Oracle but i am recieving a error ORA-01843: not a valid month when inserting a date.</p>
  
  <p>The date in the file is held as 27-01-2014</p>
  
  <p>The format in my table is set to DATE.</p>
  
  <p>This is the control file.</p>
  
  <pre><code>load data
  infile 'file1.csv'
  append
  into table my_table
  fields terminated by ',' TRAILING NULLCOLS
  (Case_reference, Attempt_Number, Dialled_Number, Date_Called)
  </code></pre>
  
  <p>Any one know where im going wrong?</p>
  
  <p>Cheers</p>