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!

NLS_DATE_FORMAT and SQL Loader

350914Jun 29 2006 — edited Jun 29 2006

Hello All,
Okay. I've read all the other posts about nls_date_format but all seem to imply that you have to use the "alter session set NLS_DATE_FORMAT" command to get the format needed. My issue is this:
My Oracle 10gR2 database on Windows has the NLS_DATE_FORMAT = "YYYYMMDD" in the init file and the sqlload process doesn't seem to see the init.ora param NLS_DATE_FORMAT.
My source text file has dates in the range from 19550101 (Jan 1 1955) to 20991231 (Dec 31 2099) . My control file for the load does a to_date funciton as follows:
MATUR_DT POSITION(78:85) "to_date(:MATUR_DT,'YYYYMMDD')"

The data for anything above 20500101 (Jan 1 2050) is being convert back to 19XX. Any suggestions?

Message was edited by:
jedsousa@yahoo.com

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 27 2006

Added on Jun 29 2006

#general-database-discussions

4 comments

1,032 views