Skip to Main Content

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!

Loading single digit months with SQLLDR

357111Jan 4 2006 — edited Jan 9 2006
How can I load dates with the month having a single digit using sqlldr??

62305220507 in this example the date is 23-Jun0-05 22:05:07
111804115452 in this example the date is 18-Nov-04 11:54:52

I've tried the date mask mmddyyhh24miss but only the double digit months get loaded.

Thanks,
Paul
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2006
Added on Jan 4 2006
2 comments
322 views