Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Formatting time fields in SQL*Loader

Re: Formatting time fields in SQL*Loader

From: <hclarius_at_mindspring.com>
Date: Sun, 13 Feb 2000 10:49:11 -0800
Message-ID: <38A6FCA7.4FA88411@mindspring.com> 





Base on my extensive experience (2 months) you need to
specify the format in your control file.



Example, if the date you wish to load is formatted like
09121999 (MMDDYYYY) the line in your control file should
look like this



Mydate DATE(8) "MMDDYYYY",


Received on Sun Feb 13 2000 - 12:49:11 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US