title: storing date and time value through SQL LOADER
body: <p>I am trying to write a control file for a sql loader.
  The source file to which is in fixed length format.
  I have date and time present in the source file like say , from position 17 to position 24 for date in <code>CCYYMMDD</code> format and from position 25 to 34 in <code>HH:MM:SS24</code> format.
  I like to store this date and time value form source file in a date column in some table in 'YYYYMMDD HH24:MI:SS' format.</p>
  
  <p>Can Anybody please help in telling how to achieve this in control file of sql loader?</p>
  
  <p>Would following piece of code do? I doubt since there is no space between the date and time in the source file?</p>
  
  <pre><code>APPEND INTO TABLE target_table
  TRAILING NULLCOLS
  (
  date_column POSITION(17:34) "TO_DATE(:DATE_TIME,'YYYYMMDD HH24:MI:SS')"
  )
  </code></pre>
  
  <p>Any lead would be highly appreciated</p>