How to setup the default 4-digit year as '19xx' for xx>'60' and '20xx' for xx<=60 without using trig
Hi,
Our daily data loading script is using SQL Loader to text file with date format as 'YY/MM/DD' .
For example:
81/11/19
18/01/21
87/03/23
90/08/13
96/05/05
After data were loaded, all of them are saved as
2081/11/19
2018/01/21
2087/03/23
2090/08/13
2096/05/05
We want them as below:
1981/11/19
2018/01/21
1987/03/23
1990/08/13
1996/05/05
We don't want to use trigger on stage table when load data.
SQL> select to_char(to_date('98/09/26','YY/MM/DD'),'YYYY/MM/DD') FROM DUAL;
TO_CHAR(TO
----------
2098/09/26
Is there any default setting on database? Do I have to update the SQL Loader control file?
Thanks
Xiaogang