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 date-time data from Excel file

782109Jun 29 2010 — edited Jul 1 2010

I am running into problems importing date-times in the format 3/15/2010 9:30:00 PM using SQL Developer. At Step 1 of the Data Import Wizard, the data preview window displays all the date fields as Excel dates (e.g. 40252.89583 instead of 3/15/2010 9:30:00 PM). Can I get SQL Developer to recognize the data in their date-time format, rather than converting them to decimal values?

This post has been answered by IckyIckyChiMoon on Jun 30 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 29 2010

Added on Jun 29 2010

#date, #excel, #sql-developer, #time

4 comments

6,989 views