Oracle date field

[akarsh]

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.

[chulett]

Do an exact search here for "century pivot", this has been asked and answered before and that will turn the discussions up.