Hi,
I am trying to load some data using SQL Loader.
If I try to insert a date prior to 1950 (ie 1942 for example) then it's loaded as 2042 in my oracle table !
What's the problem... ? Is there a parameter I should change ?
Thanks.
Fabien
Printable View
Hi,
I am trying to load some data using SQL Loader.
If I try to insert a date prior to 1950 (ie 1942 for example) then it's loaded as 2042 in my oracle table !
What's the problem... ? Is there a parameter I should change ?
Thanks.
Fabien
Post us ur sample data(1 row from ur datafile), control file
& also description of ur table...
Hi
try this...
set NLS_DATE_FORMAT using 'RR' or 'YYYY'.
HTH
pras