Date format issue
Posted: Fri Mar 11, 2011 11:25 am
Hi ,
I have a requirement to load date on file name to a date column in oracle table.
Source---> .txt file ,Target - Oracle
My filename is like XYZ_20100630_1.txt.
I parameterized filename and used field function in stage variables to grep date on filename.
sv1=Field(pFilename,"_",3,1)
sv2=svMonth:"/":svDate:"/":svYear
I mapped sv2 to taget date column(date ,Nullable) in the database.
After loading i could see the date loaded as 2/16/4698 in the database.
Can someone help in here.
thanks,
I have a requirement to load date on file name to a date column in oracle table.
Source---> .txt file ,Target - Oracle
My filename is like XYZ_20100630_1.txt.
I parameterized filename and used field function in stage variables to grep date on filename.
sv1=Field(pFilename,"_",3,1)
sv2=svMonth:"/":svDate:"/":svYear
I mapped sv2 to taget date column(date ,Nullable) in the database.
After loading i could see the date loaded as 2/16/4698 in the database.
Can someone help in here.
thanks,