Question: how to convert date format from dd/mm/yyyy to mm/dd/yyyy in informatica?
Answer: For example, if you pass the string '20150515', you must use the format string 'YYYYMMDD'. v_PORT(DataType-DateTime)-TO_DATE(TO_CHAR(INPUTPORT),'DD/MM/YYYY') o_PORT(String)--TO_CHAR(v_PORT,'MM/DD/YYYY') It will work.