| SQLLDR and time [message #69352] |
Fri, 14 December 2001 05:56  |
Rose C
Messages: 2
Registered: December 2001
|
Junior Member |
|
|
I am having two problems. The first occurs when I am trying to load time info into a table. The time data is in the format MM:SS. The fields within a record are delimited with |. I'm using the control statement
duration date 'mi:ss'
When I try loading the data, I get the following error message,
Record 1:Rejected - Error on table LDCACADLOAD, column DURATION.
ORA-01843: not a valid month
My second problem is that most of the data in duration is stored as MI:SS format. If by chance an hour has expired, the data appears as HH:MI:SS. Is there a way to load both of these formats together?
I should also mention that we behind the times and are still running 7.3.4.
Thanks in advance for any help
Rose
----------------------------------------------------------------------
|
|
|
|
| Re: SQLLDR and time [message #69355 is a reply to message #69352] |
Fri, 14 December 2001 07:35  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
oracle stores time as part of date. so you have to supply date part when you want to insert value into date column. if you have only time part ,
change column datatype to varchar2.
----------------------------------------------------------------------
|
|
|
|
| Re: SQLLDR and time [message #69360 is a reply to message #69355] |
Fri, 14 December 2001 09:04 |
Rose C
Messages: 2
Registered: December 2001
|
Junior Member |
|
|
I have another time field and it loads fine without any date information attached. That field is called CallTime and its format is
calltime date 'hh:miam'
So why does this field load and the other one doesn't?
Rose
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
