Skip to Main Content
Forums

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 date format

user645399Jun 17 2010 — edited Jun 18 2010
Dear buddies,

I am loading some files from text file to Oracle.

The table has a column with date format.

The text file has dates which are in such formats: 29-05-2007 15:27:25.147

I tried altering the table to timestamp but even that only accepts 2 digits for the millisecond and I tried setting
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SSXFF'; which is not possible. Only possible to set the milliseconds to 2 digits.

Please advice on how I can go about this.

Thanks in advance.

Nith
This post has been answered by Nicolas Gasparotto on Jun 17 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2010
Added on Jun 17 2010
#general-database-discussions
2 comments
1,128 views