It's a multi-step process. First load the data into a column of type
"char" (CHAR_COL). Second, add a column of type "date" (DATE_COL).
Third, analyze the values you have. Fourth, build the PL/SQL (or any
other programming to you prefer) to update each row setting the
DATE_COL to be TO_DATE(CHAR_COLUMN,'<date format of your choice>')
based on the value in CHAR_COL. (If length(CHAR_COL) = 6 AND SUBSTR
(CHAR_COL,1,2)=99 THEN ...
r and good luck,
Gus
On Oct 3, 2007, at 3:44 PM, Harvinder Singh wrote:
Hi,
We have a flat file that contains a column and the values are
stored as:
991123
421
60823
0
70930
Now we are moving data from flat file to table and this column will be
inserted into Date dataype column, What is the way to insert into this
table and avoid "ORA-01821: date format not recognized" errors.
Thanks
--Harvinder
--
http://www.freelists.org/webpage/oracle-l
