Problem regarding data import / timestamp
Hi there,
I´m trying to create a table with a timestamp(6) column and fill it with data imported from a csv-file. The timestamp format is:
26.01.01 16:54:35
The import runs without error messages, but in the 9i Navigator the timestamp data isn`t shown, instead a little icon is displayed. When exporting the file again, the timestamps are cut off, like:
26.01.01 16:
How has the timestamp data to be formatted, and/or doesn`t the 9i Navigator support timestamp data?
Thanks,
Andreas