RE: Date conversion question

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Thu, 4 Oct 2007 07:37:59 -0500
Message-ID: <D40740337A3B524FA81DB598D2D7EBB3097A8CC1@x6009a.umb.corp.umb.com>

The simplest way would probably be to define an oracle external table of just lines of the appropriate length, then read the data as lines and parse each line character by character into the format you require, then insert the parsed data into a standard oracle table. Pretty standard stuff...

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Harvinder Singh Sent: Wednesday, October 03, 2007 2:44 PM 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

---

NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

---

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 04 2007 - 07:37:59 CDT