Date format... in control file

Date format... in control file

 

  

Dear Gurus,

Greetings. I have the csv file with format '59-03-03'
this needs to be stored in oracle like 1959-03-03

if i try to load using 'YY-MM-DD' i am getting value in table like
2059-03-03

in control statment i tried by 'YYYY-MM-DD'

But i am getting error can u please help me how to load this into the
tables

Thanks
Mudhalvan M.M


Oracle LazyDBA home page