TO change the century in the MLOAD (i.e 1900 to 2000)

Database

TO change the century in the MLOAD (i.e 1900 to 2000)

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.

Thanks

pmanch1

4 REPLIES

Re: TO change the century in the MLOAD (i.e 1900 to 2000)

*typo mistake

In the table it is showing me as 2/29/1912

Thanks

Supporter

Re: TO change the century in the MLOAD (i.e 1900 to 2000)

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.

Re: TO change the century in the MLOAD (i.e 1900 to 2000)

Thanks ulrich...

Could you please tell me the full line code..??

I am new to this.!!

Thanks

Supporter

Re: TO change the century in the MLOAD (i.e 1900 to 2000)

Can you share your full line of code? Then we know what you are doing...