SQL Developer

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!

Data Import Wizard from Excel on DATE column

742416Dec 30 2009 — edited May 4 2010

I have exported data to a csv in Oracle SQL Developer and one of the columns are of an Oracle Date datatype. In opening up Excel I see the Date column represented as 15-MAY-01 12.00.00.000000000 AM.

I am now going through the Data Import Wizard to create a new table and import the data. When I get to Step 3 of 4 it reads the data and assigns it a VARCHAR2. I want the column to be Date or Timestamp. In this case I choose timestamp and for format entered DD-MON-YY hh.mi.ss.fffffffff AM.

When I go to Step 4 of 4 to and click the Verify button I get:
"Verifying if the Date columns have date formats" Date columns DOT_LOGN_EFDT, have invalid or null date formats.

I am using Oracle SQL Developer 2.1.0.63 Build 63.73.

Any idea what I put in the format window to read the excel value of 15-MAY-01 12.00.00.000000000 AM correctly?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2010

Added on Dec 30 2009

#data, #import, #sql-developer, #sqldeveloper

4 comments

6,557 views