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!

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.

Importing date/time field from excel using SQLDeveloper

user572941Jan 31 2013 — edited Feb 1 2013

I am having problems trying to load a date/time field from an excel spreadsheet using the import function of SQLDeveloper (3.2.20.09). I've tried changing my default date format in SQLDeveloper and also supplying a format during the import. I can't get it to load any time other than 12:00:00 AM. Does anyone know how to do this? How does the field need to be formatted in Excel? What is the correct syntax of the date/time format in SQLDeveloper?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 1 2013

Added on Jan 31 2013

#sql-developer

8 comments

18,731 views