3 Replies Latest reply on Mar 26, 2015 6:49 PM by rmoff

    Import data - time format drop literals - bug?

    rmoff

      SQL Developer 4.1 EA2

       

      If I set up a data import using INSERTs and specify a format string for a timestamp field that includes literals, these get dropped in the resulting generated INSERT statements:

      Format used: YYYY-MM-DD"T"HH24:MI:SS.FF3"-07:00"

      Data_Import_Wizard_-_Step_4_of_5.png

      Resulting INSERT:

      Oracle_SQL_Developer____var_folders_py_jrrk_5490y95w7816tzqbygm0092f2_T_Import-phys-reqs-by-user-time-tsv_1_sql.png

      Throws the expected:

      SQL Error: ORA-01821: date format not recognized

       

      Fix the format:

      Oracle_SQL_Developer____var_folders_py_jrrk_5490y95w7816tzqbygm0092f2_T_Import-phys-reqs-by-user-time-tsv_1_sql.png

      Works as it should:

      1 row inserted.

       

       

      (I'm aware that I'm butchering the timestamp/timezone - that's by the by ;-) )