Problem Loading Date/Time Field [message #74174] |
Tue, 28 September 2004 10:36 |
Fuad H
Messages: 6 Registered: September 2004
|
Junior Member |
|
|
I have a field that has been defined as TIMESTAMP in a table using Oracle9i.
The field in the data file contains 2001093013162320 (yyyymmddhhmisstt)
SQLLDR won't accept this as a Date or Timestamp.
[[Record 9: Rejected - Error on table AR3_RECORD, column AR3_TIMESTAMP_DATE. ORA-01821: date format not recognized ]]
I have tried numerous types Date/Time format in my CTL file:
e.g
AR3_TIMESTAMP_DATE POSITION(42:57) TIMESTAMP 'yyyymmddhhmisstt',
AR3_TIMESTAMP_DATE POSITION(42:57) TIMESTAMP 'yyyymmdd hhmisstt',
AR3_TIMESTAMP_DATE POSITION(42:57) TIMESTAMP 'yyyymmdd hh:mi:ss.tt',
even tried the following:
AR3_TIMESTAMP_DATE POSITION(42:57) "to_date(:AR3_TIMESTAMP_DATE, 'yyyy-mm-dd hh24:mi:ss.tt'),
Any other suggestion anyone?
FuadH
|
|
|
|