Page 1 of 1
Date Conversions In Modify Stage
Posted: Wed Jan 02, 2008 8:12 am
by iamnagus
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.
Posted: Wed Jan 02, 2008 8:23 am
by ArndW
So, by posting this 3 times you think that you will get an answer 3x faster? Not from me.
Posted: Wed Jan 02, 2008 5:04 pm
by ray.wurlod
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.