| sqlldr and date conversion [message #69964] |
Sun, 24 March 2002 13:10  |
Thusitha
Messages: 2
Registered: March 2002
|
Junior Member |
|
|
Hello,
I am trying to load the DATE field from a Sybase
database to Oracle using Sqlldr. In the .dat file for
this table, DATE field appears as follows:
Mar 15 1986 12:00:00:000AM
Below is the control file that I used to extract the
table data:
load data
infile 'CHILD.dat' "str '<er>'"
into table CHILD
fields terminated by '<ec>'
trailing nullcols
(MEDREC ,
FIRSTNAME ,
LASTNAME ,
BIRTHDATE DATE 'MON DD YYYY HH24:MI:SS' ,
SEX ,
BIRTHWT ,
CONGABN ,
HOSP ,
UPDATEID ,
UPDATEDATE DATE 'MON DD YYYY HH24:MI:SS',
ENTRYID ,
ENTRYDATE DATE 'MON DD YYYY HH24:MI:SS',
TIMESTAMP FILLER)
The sqlldr error message for this control file was:
ORA-01830: date format picture ends before
converting entire input string.
The input string for the DATE field ( Mar 15 1986
12:00:00:000AM) has 26 characters for the date
field. Can anyone help me to figure out what mast
should be used for the DATE field in the control
file?
Thanks,
Thusitha
|
|
|
|
| Re: sqlldr and date conversion [message #70305 is a reply to message #69964] |
Wed, 22 May 2002 21:34  |
Sheila
Messages: 28
Registered: May 1998
|
Junior Member |
|
|
|
Your input date is not in 24-hour format, but has a meridian indicator (am/pm) at the end, so I think your full date format picture should be 'MON DD YYYY HH:MI:SSAM'
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
