title: Oracle sqlldr timestamp format headache
body: <p>I'm struggling to get <code>sqlldr</code> to import a csv data file into my table, specifically with the field that is a timestamp.</p>
  
  <p>The data in my csv file is in this format:</p>
  
  <pre><code>16-NOV-09 01.57.48.001000 PM
  </code></pre>
  
  <p>I've tried all manner of combinations in my control file and am going around in circles. I can't find anything online - not even the Oracle reference page that details what all the date/timestamp format strings are.  </p>
  
  <p>Does anyone know where this reference page is, or what format string I should be using in my control file for this timestamp format.</p>
  
  <p>For reference, this is what I've most recently tried:</p>
  
  <pre><code>load data
  infile 'kev.csv'
  into table page_hits
  fields terminated by "~" 
  ( ...
    event_timestamp TIMESTAMP "dd-mmm-yy hh24.mi.ss", 
  ...)
  </code></pre>