SQL & PL/SQL

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!

ORA-01861: literal does not match format string

937454Aug 29 2013 — edited Sep 4 2013

Hi,

My db version:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

My control file has this detail for a date column:

LASTLOGINDATE DATE "yyyy-mm-dd hh24:mi:ss"

My csv file has data in this format for the date column:

2009-03-02T14:29:04.000Z

I am getting this error:

Record 2: Rejected - Error on table core.user, column LASTLOGINDATE.

ORA-01861: literal does not match format string

I tried theses following different formats in control file, but get another error:

LASTLOGINDATE DATE "TO_DATE(:LASTLOGINDATE, 'YYYY-MM-DD HH24:MI:SS.FF')"
LASTLOGINDATE DATE "TO_DATE(:LASTLOGINDATE, 'YYYY-MM-DDTHH24:MI:SS.FFF')"
LASTLOGINDATE TIMESTAMP "yyyy-mm-dd hh24:mi:ss"

ORA-01821: date format not recognized

Please advice, how should I edit my control file to accomodate the date values.

This post has been answered by Etbin on Aug 30 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 2 2013

Added on Aug 29 2013

8 comments

3,147 views