8 Replies Latest reply on Feb 1, 2013 1:29 PM by user572941

    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 ( 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?