Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQLLDR ORA-01858 and ORA-01861 while converting Date dd.mm.rr

user134954Dec 13 2011 — edited Dec 13 2011

Hi,

I am trying to get some Excel-Data in my Database.

The Data is formatted : 02.01.2011; ";" is the seperator

The column is named RD_DATE

I have tried :

RD_DATE DATE "dd.mm.rr" but it fails with ORA-01858 and 01861

While trying in Apex it works fine with dd.mm.rr.

The other Data seems to work well, but the Date fails everytime.

NLS-Lang in the Session is Germany and Date Format is dd.mm.rr

Thx 4 your help

Edited by: user12091690 on 12.12.2011 23:39

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 10 2012

Added on Dec 13 2011

#database-key-features, #export-import-sql-loader-external-tables

3 comments

1,304 views