How to solve error gdk-05030 when importing csv data in SQL Developer-CodePudding

I have a problem importing a CSV file using SQL Developer. I created a table to import a 'date' data by using the code below

CREATE TABLE DEPARTMENT (
  DATECOLUMN DATE
);

I imported the CSV by right clicking and so on.

Interestingly, the CSV 'date' data has a format of 'YYYY-MM-DD', but when loaded in SQL developer (preview, before importing), it took the format of 'MM/DD/YYYY'.

I believe this is the problem, because when trying to import, it returned error "gdk-05030", meaning the data contains more than needed (to fit the format).

CodePudding user response：

To me, it looks as follows:

date format in a CSV file is yyyy-mm-dd (as you said)
when you queried the table after insert, you found out that values look differently - mm/dd/yyyy
it is because current settings use that date format. If you want to change it, run
```
alter session set nls_date_format = 'yyyy-mm-dd';
```
and then select rows from the table.
alternatively, go to SQL Developer's Preferences, and set desired date format in its [Database - NLS] section.