This discussion is archived
8 Replies Latest reply: Feb 1, 2013 5:29 AM by user572941 RSS

Importing date/time field from excel using SQLDeveloper

user572941 Newbie
Currently Being Moderated
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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points