How to handle date conversions in data stage? Convert an mm/dd/yyyy format to yyyy-dd-mm?

Ans). We use a)”lconv” function – Internal Conversion.

                 b) “Oconv” function – External conversion.

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