RE: Date conversion question
- From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
- To: Harvinder.Singh@xxxxxxxxxxxxx, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 4 Oct 2007 07:37:59 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//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.
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts: