5 Replies Latest reply: Mar 25, 2014 8:02 PM by user571093 RSS

    import temporal data in timestamp with timezone in sql developer


      Dear all,



      I'm trying import a csv file to a table in sql developer but can't succeed. The reason is that a column in the csv file contains temporal data in this kind of format

      "2010-10-20 22:00:00 EST".  I tried timestamp with or without timezone format in sql developer without success. Can anyone please point out a direction to solve the issue?

      Thanks a lot in advance.