Question: how to convert dd/mm/yyyy to yyyy-mm-dd in datastage?
Answer: Here is the right conversion:Function to convert mm/dd/yyyy format to yyyy-dd-mm is Oconv(Iconv(Filedname,"D/MDY[2,2,4]"),"D-YDM[4,2,2]") .