4 Replies Latest reply on Jul 11, 2018 12:18 PM by EdStevens

    SQL Developer 18.1 export tool uses lossy date format

    2951300

      The table export tool in SQL developer exports dates using a lossy conversion to and from strings.

       

      create table test_date (test_date date);

       

      insert into test_date values (date'2118-07-10');

      insert into test_date values (date'2018-07-10');

      insert into test_date values (date'1918-07-10');

      insert into test_date values (date'1818-07-10');

      insert into test_date values (date'1718-07-10');

      commit;

       

       

      -- output of table export tool

      REM INSERTING into ALISTAIR.TEST_DATE

      SET DEFINE OFF;

      Insert into ALISTAIR.TEST_DATE (TEST_DATE) values (to_date('10-JUL-18','DD-MON-RR'));

      Insert into ALISTAIR.TEST_DATE (TEST_DATE) values (to_date('10-JUL-18','DD-MON-RR'));

      Insert into ALISTAIR.TEST_DATE (TEST_DATE) values (to_date('10-JUL-18','DD-MON-RR'));

      Insert into ALISTAIR.TEST_DATE (TEST_DATE) values (to_date('10-JUL-18','DD-MON-RR'));

      Insert into ALISTAIR.TEST_DATE (TEST_DATE) values (to_date('10-JUL-18','DD-MON-RR'));

       

      Recommend using literal dates.