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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Date conversion question

RE: Date conversion question

From: Laimutis Nedzinskas <Laimutis.Nedzinskas_at_landsbanki.is>
Date: Thu, 4 Oct 2007 09:23:52 -0000
Message-ID: <5A8896FB2AFC5445A7DCFC5903CCA6B001686618@W03856.li01r1d.lais.net>


Simple is good:

Import into staging table with all columns varchar2(4000) and do whatever conversions, checks and validations you want in pl/sql

P.s. if performance, space or pl/sql knowledge is an issue then you can try to load into the target table in one pass but I would not recommend that.

P.s.s. performance and space constraints could be lifted with external tables ( all columns varchar2(4000) of course! )

Laimutis Nedzinskas
Landsbanki ═slands hf.
Gagnagrunnsstjˇri / DBA
UpplřsingatŠknisvi­ / Gagnagrunnar
IT / Database Systems
www.landsbanki.is

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Harvinder Singh Sent: 3. oktˇber 2007 19:44
To: oracle-l
Subject: Date conversion question

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

Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer
--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 04 2007 - 04:23:52 CDT

Original text of this message

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