SQL & PL/SQL

hi,

i have written a decode using to_date conversion as

select to_date(decode(01011946,'00000000',null,to_date('01011946','ddmmyyyy'))) from dual.

the purpose is , the source file i am reading is a txt file. in which the Date comes as 01011946 format.

i am reading this usinga plsql procedure
decode(substr(txt,122,8),'00000000',null,to_date(substr(txt,122,8),'ddmmyyyy')), basic dob

the target table column is DATE data type .

now for this DOB 01011946...its writting 1/1/2046.


wats the issue and how do i fix it? so that is shows 01/01/1946.

kindly help.

thanks