5 Replies Latest reply on Mar 26, 2014 1:02 AM by user571093

    import temporal data in timestamp with timezone in sql developer

    user571093

      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.