Date Conversions In Modify Stage

iamnagus · Post by **iamnagus** » Wed Jan 02, 2008 8:12 am

I have a date column my the source. In the comlum the date formats are mmddyy, ddmmyy,ddmmyyyy. I want to convert the column to the target as mmddyyyy there is In MODIFY Stage.

Can any one expain this.

ArndW · Post by **ArndW** » Wed Jan 02, 2008 8:23 am

So, by posting this 3 times you think that you will get an answer 3x faster? Not from me.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 02, 2008 5:04 pm

If the input column is a Date data type it has no particular format; Date is a binary data type within DataStage. Therefore your fundamental assumption (that you have a date with different formats) is not tenable.