Skip to Main Content

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!

Import Date and Time Values

976439Dec 10 2012 — edited Dec 11 2012
Hi, i am looking for some help in regards to import data into a new table. I have 3 columns with date and times and when importing I am changing the data type as DATE with the format specified as DD/MON/RR HH24:MI:SS (options in preference for NLS are set the same) and the size set at 255. This verifies all ok and When I finish this than I get the following error:

insert failed for row 1 time GDK-05043 not a valid month

I then changed the datatype to TIMESTAMP DD-with the format MON-RR HH24.MI.SSXFF but this still gives me the same error.

When I import with the datatype set as VARCHAR2 then this imports all the data.

An example of a date and time value from the csv is the following:

01/12/2012 22:51:57

If somebody could please help me fix this as ideally want these as date and time values in their tables. Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 8 2013
Added on Dec 10 2012
9 comments
7,019 views