Hi,
We are facing date format issue during the loading of CVS file using SQL Loader. In CSV we have date in the format mm/dd/yyyy e.g 12/28/1900
In the control file the placeholder is defined as below
DATEOFBIRTH "TRIM(to_date(:DATEOFBIRTH,'mm/dd/yyyy'))"
However on execution we see that the date 12/18/1900 is converted to 12/18/2000 in the database.
We have checked in the database and the NLS_DATE_FORMAT is set as DD-MON-RR.
Could you please let us know any pointers to resolve this issue. The issue is happening for records which is less than 1950.
It seems century ridding is causing the issue. We want a solution in the control file for fixing this issue.
SQL>
SQL> --Find the NLS_DATE_FORMAT:
SQL>
SQL> SELECT value FROM v$nls_parameters WHERE parameter ='NLS_DATE_FORMAT';
VALUE
----------------------------------------------------------------
DD-MON-RR