How to handle Date convertions in Datastage? Convert mm/dd/yyyy format to yyyy-dd-mm?

 

We use

  • “Iconv” function – Internal Convertion.
  • “Oconv” function – External Convertion.Function to convert mm/dd/yyyy format to yyyy-dd-mm is Oconv(Iconv(Filedname,”D/MDY[2,2,4]”),”D-MDY[2,2,4]”)

Leave a Reply