title: EDT and EST timestamp sqlldr data load in oracle
body: <p>I have issue while loading data from flat file to Oracle database with Timestamp column via sqlloader.
  The problem is I have a data for both EST and EDT like below mentioned format</p>
  
  <p><strong>test_data.dat</strong></p>
  
  <pre><code>Thu Mar 07 14:27:14 EST 2013
  Thu Mar 07 14:27:27 EST 2013
  Tue Apr 09 18:20:54 EDT 2013
  Tue Apr 09 18:24:26 EDT 2013
  </code></pre>
  
  <p><strong>My sqldrfile.ctl</strong> code is below</p>
  
  <pre><code>LOAD DATA
  INFILE 'test_data.dat'
  TRUNCATE
  INTO TABLE MY_TABLE    FIELDS TERMINATED BY '|'
  TRAILING NULLCOLS
  (
          "DOC_DATE_ADDED" TIMESTAMP WITH TIME ZONE "DY MON DD HH24:MI:SS TZR YYYY",
  )
  </code></pre>
  
  <p><strong>Rejected_data.bad</strong> the below two records not recognized and went to bad file</p>
  
  <pre><code>Tue Apr 09 18:20:54 EDT 2013
  Tue Apr 09 18:24:26 EDT 2013
  </code></pre>
  
  <p>Other two EST records loaded correctly into oracle table.. I need a sqlldr code to load for both the timestamp EST and EDT. Please guide me on this.. :(</p>