I have to load date field in oracle table,It loading as 1900 base while i need to load in 2000 base.
eg
current output
Input -> Output
07-23-01 -> 07/23/1901
desired output
07-23-01 -> 07/23/2001
I am using StringToDate(inputfield ,"%mm-%dd-%yy") function.
Please advise how to fix this.
Oracle date field
Moderators: chulett, rschirm, roy
Oracle date field
Thanks,
Akarsh Kapoor
Akarsh Kapoor