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

We use a) "Iconv" function - Internal Convertion.
b) "Oconv" function - External Convertion.

Function to convert mm/dd/yyyy format to yyyy-dd-mm is

Showing Answers 1 - 11 of 11 Answers


  • Jun 27th, 2005

but what is the difference between diff.types of hash files

  Was this answer useful?  Yes


  • Sep 18th, 2005

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]") .

  Was this answer useful?  Yes


  • Jun 5th, 2006

ToChar(%date%, %format%)

This shuld work, in format specify which format u want i.e 'yyyy-dd-mm'

  Was this answer useful?  Yes


  • May 6th, 2007

we can  achieve this conversion using transformer stage conversion functions in PX.


  Was this answer useful?  Yes


  • Dec 16th, 2009

I will explain how to Convert a mm/dd/yyyy format to yyyy-dd-mm
Below is the format

Oconv(Iconv(Filedname D/MDY[2 2 4] ) D-YDM[4 2 2] )

here first Iconv(Filedname D/MDY[2 2 4] ) will convert our given date in the internal format

later  Oconv( Inter_date_format D-YDM[4 2 2] ) will convert our internal date format to required yyyy-dd-mm...



  • May 30th, 2013

by default datastage date format is :yyyy-mm-dd.The input is mm/dd/yyyy.
Date To String(inputdate,"%mm%dd%yyyy")

  Was this answer useful?  Yes


  • Jul 29th, 2013

by default datastage date format is :yyyy-mm-dd.The input is mm/dd/yyyy. String_to_date(inputdate,"%mm%dd%yyyy")

  Was this answer useful?  Yes

vipul choudhary

  • Aug 22nd, 2013

There are two types of hash file

1. modulus hash file- file size increases randomly
2. splitting hash file-file size decreases randomly

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions


Related Open Questions