Can't convert varchar into date using sas data integation studio

152 Views Asked by At

I am new using sas data Integartion Studio 4.9005. i am using database oracle 18.

the scenario is i move from table_A with data type varchar(100) to table_B with date data type.

the format from table_A is YYYY/MM/DD enter image description here

but the result is give me random number (01-01-1960) it doesn't make sense.

enter image description here

for code to convert is "INPUT( TANGGAL_LAHIR ,yymmdd10.)"

enter image description here

Is there i am missing ? Thank you very much.

0

There are 0 best solutions below