DSXchange

You are right and I've been attempting to make it work that way. On my source column meta it comes in as a Decimal( 8 ), my destination is a Date, in the SQL that datastage auto generates it is using TO_DATE() INSERT INTO .... VALUES (... MY_DATE_COLUMN=TO_DATE(:73, 'DD-MON-YYYY') .... ) And in my t...

Do you know how to format to 08-AUG-2012?

OConv(IConv(YourField,"D"),"DMA" : @VM :"MCT") ... I found your post and it's given me hope to my similar problem, in your example you return a full month name, what if I just want an abbreviated month, so August would be Aug, and June would be Jun. The Big Picture My ...

I have an 8 digit integer formatted like YYYYMMDD, example would be 20120808 and I need in the transformer to convert it to a date so oracle will accept it. I have tried using this code Oconv(Iconv(Arg1,"DYMD"),"D-YMD[4,2,2]") but I just get Attempt to convert String value "...