title: Setting the Date Format in the SQL*Loader Control File
body: <p>I have csv file that has "17 September, 2009 11:06:06 AM" as COMPLETED_ON variable</p>
  
  <p>I am using sql loader to load data to oracle with folowing:</p>
  
  <pre><code>LOAD DATA
  INFILE 'c:/load/file_name.csv'
  APPEND
  INTO TABLE tbl_name
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  (
  COMPLETED_ON DATE "not sure what to put here",
  ) 
  </code></pre>
  
  <p>in oracle I have this column created as follows:</p>
  
  <p>"COMPLETED_ON" TIMESTAMP (0) WITH LOCAL TIME ZONE</p>
  
  <p>How do I change COMPLETED_ON date in control file?</p>