SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

import temporal data in timestamp with timezone in sql developer

user571093Mar 25 2014 — edited Mar 25 2014

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.

This post has been answered by thatJeffSmith-Oracle on Mar 25 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 22 2014

Added on Mar 25 2014

#sql-developer

5 comments

1,100 views