Importing date/time field from excel using SQLDeveloper
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?