Date conversion question

["Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>]

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

• Follow-Ups:
  • RE: Date conversion question
    • From: Bobak, Mark
  • Re: Date conversion question
    • From: Rumpi Gravenstein
  • Re: Date conversion question
    • From: August Spier
  • Re: Date conversion question
    • From: Gints Plivna
  • RE: Date conversion question
    • From: Laimutis Nedzinskas
  • RE: Date conversion question
    • From: Kerber, Andrew W.

• References:
  • RE: Optimizer sees index, but ignores it in access path decision process
    • From: Baumgartel, Paul

Other related posts:

Date conversion question

RE: Date conversion question

RE: Date conversion question

RE: Date conversion question

RE: Date conversion question

Re: Date conversion question

RE: Date conversion question

Re: Date conversion question

RE: Date conversion question

Re: Date conversion question

RE: Date conversion question

RE: Date conversion question