I have a field PRO_DT in the teradata which is of type "(YY/MM/DD)".
I have an input file with the value for that field is "12/02/29".
When i insert this value into the table, it is showing me as 2/12/1912
It is taking by default century as 1900, i want to change it to 2000.
Can anyone please help me on this.
easiest might be to concate '20' to your date string and use 'YYYY/MM/DD' for the conversion.
It is also not advisable to define 'yy/mm/dd' as it has the pontential to confuse people again and again and again.
You can change as well the Century Break dbs controll field but this might have some other negative side effect.