title: SQLLDR Oracle Data Import, Date Format = yyyy-mm-dd
body: <p>I am trying to import data from a flat file into Oracle 11gr2 using SQLLDR, and i have 3 columns with date formats like "yyyy-mm-dd".  Oracle keeps throwing errors when I try to import the data like this.  Is there a quick solution to just import the data in this format?  I would prefer to not have to change the format of the data in the file since it is very large.</p>
  
  <p>Here is an example of the error listed in the log.ct:</p>
  
  <blockquote>
    <p>Record 51: Rejected - Error on table LINEITEM, column L_SHIPDATE.
    ORA-01861: literal does not match format string</p>
  </blockquote>
  
  <p>Thanks!</p>