Skip to Main Content
Forums

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!

Importing from excel doesn't work on date fields

711683Jul 13 2009 — edited Oct 21 2009
I'm trying to import from an excel file, and two of the fields are dates. When I look at the resulting Insert statement, I see this:

to_date('39896.0', 'MM/DD/YYYY HH:MI:SS')

Which, of course, does not work. Where is this '39896' coming from?

I've seen a few other people with this issue, but no solutions. Is there a suggestion box or something? This tool could be great, but as it stands, even when it works it's too hard to use.

Comments

EJP
I'm inclined to agree with the Java 7 compiler here. Did you really mean to put S and T back to front in the specification of T?
955312
As name of the class says it's strange one...
It's just stupid example - more interesting is change of compiler behavior...
If it should not compile why is it compiling under java 6?
gimbal2
Answer
Because they're two separate things? Java 7 is NOT simply an "upgrade" from Java 6, its a new platform. Therefore things can and will be different.

Might in this case simply be that a bug in the compiler was plugged though.
Marked as Answer by 955312 · Sep 27 2020
955312
Thank you for answer.
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 18 2009
Added on Jul 13 2009
#error, #excel, #import, #sql-developer
16 comments
3,823 views