DATE in SQL Loader
From: greg teets <teetshd_at_ucbeh.san.uc.edu>
Date: 1997/07/27
Message-ID: <33db4edf.135729426_at_news.ececs.uc.edu>#1/1
Date: 1997/07/27
Message-ID: <33db4edf.135729426_at_news.ececs.uc.edu>#1/1
[Quoted] [Quoted] I'm trying to load some date with SQLLoader that do not have a zero [Quoted] when the month or day is less than ten. I am currently using the following line in my .ctl file:
QUOTE_DATE_DATE DATE "FXFMMM/MM/YY", I got this syntax from the section on Format Models in the manual. However, I got the error:
ORA-01810: format code appears twice
when I ran Loader.
Am I on the right track? If not, please explain how to load records which drop the zero in this situation.
Thanks in advance.
Greg Received on Sun Jul 27 1997 - 00:00:00 CEST