Specify the date format when importing data into SQL Developer

Question

I am trying to import data into a CSV file using Oracle SQL Developer. One of the columns in the CSV file is the date, which is in the format ISO-8601 2012-08-22T00:06:52.0Z with a fractional second, as always 0. The corresponding column in the table is of type date . Oracle SQL Developer has the ability to specify the date format during the import process, so I specify the format as

 YYYY-MM-DD"T"HH24:MI:SS."0Z" 

But the import process is not possible because the date format is not recognized. To insert statements that Oracle SQL Developer generates in some way is to remove double quotes from the date format.

 INSERT INTO TABLE(CREATION_DATE, LAST_MODIFIED_DATE) VALUES (to_date('2009-02-18T00:06:52.0Z', 'YYYY-MM-DDTHH24:MI:SS.0Z'),to_date('2012-08-30T00:06:52.0Z', 'YYYY-MM-DDTHH24:MI:SS.0Z')); 

Any suggestions to fix this problem?

Answer 1

Have you tried to escape characters in the date format specification? if this does not work, you must open SR.