Oracle Database Discussions

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!

Sqlldr control file and est/edt date format

209473Oct 1 2008 — edited Oct 1 2008

Hi,
I am trying to figure out how to create an entry in an sqlldr control file to handle date values (in a csv file) in the following formats:

Example:
2008-09-23 12:46 EDT
2008-01-18 07:00 EST
2008-09-24 03:48 EDT
2008-04-04 13:49 EDT
2008-04-25 12:42 EDT
2008-05-02 13:25 EDT

Date and time are ok. Don't know what to do for EST/EDT.
Any sugg?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 29 2008

Added on Oct 1 2008

#general-database-discussions

3 comments

2,376 views