Thank you for answer.
Please, look at the screenshots. Here is how it look in Excel. There is fields of Custom format 'dd.mm.yyyy hh:mm:ss'
While exporting in Oracle SQL Developer on step 1 it's already represented in format 'mm/dd/yyyy'
and 'hh:mm:ss' part is not shown.
Although I have configured NLS Date format.
Have a nice day.
you have to come up with an Oracle date format that matches how the dates are written in your spreadsheet
Sorry, Jeff. I don't understand, what do you mean.
I need to change settings in SQL Developer, or Excel?
you don't need to change settings ANYWHERE
in the wizard, you need to describe to sql developer how the text string in Excel can be interpreted as a DATE to Oracle
pretend you were writing an INSERT statement with that exact string, and you were going to use the TO_DATE() function. What would be the date format you would use in the TO_DATE call to let Oracle see your string as a date?
Jeff, format will be as in Excel spreadsheet - 'dd.mm.yyyy hh:mm:ss'
The strange thing, at step 1 wizard already does not see part hh:mm:ss
I think the matter in Excel, because I converted .xls to .csv and successfully imported as timestamp 'dd.mm.yyyy hh:mm:ss'
But still interesting, why does not worked with .xls
Could you will try to create excel spreadsheet with field with custom format 'dd.mm.yyyy hh:mm:ss' - for example with '05.02.2015 17:55:06' value and import with SQL Developer?