This content has been marked as final. Show 4 replies
I am not able to reproduce your problem. When I export a date column, I do not get the time portion. This is the expected behavior. When re-importing the date, I therefore have no problem. I have tried manipulating the tools->preferences->database->nls->date format mask to include the time (and fractional seconds), but export still only exports the date portion. The fractional seconds is not valid for a date field, which explains the import error you are getting. The question remains as to why the exported data has the time. Can you describe your exact steps for doing the export?
Hi Keith Brockman,
Have you solved this issue? I am encountering the same problem as yours. I cannot import the dates from excel with timecomponent.
Sample exported data: '31-MAY-09 10.44.22.000000000 AM'
In the data import wizrd of SQL developer, what should I enter as the date format mask?
Edited by: user13038177 on May 3, 2010 10:48 PM