-
I have a large data file with dates in the following format:
YYYY-DD-MON HH24:MI:SS.nnn where the nnn is time compoonent in milliseconds.
This file is from an external system, I have no influence on it.
It is comma separated.
In a SQL*Loader CTL script I have the following
(
ACCESS_DATE DATE "YYYY-DD-MON HH24:MI:SS"
)
This fails as format string does not match the data. What can I use for the .nnn component.
I have tried delimited by '.' to stop input at the decimal point however this fails when the field is null.
Also I have done
(
ACCESS_DATE CHAR "TO_DATE(SUBSTR(.......))"
)
This worked but stops me using direct path load.
Any ideas?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|