DSXchange

Hi All,

I have date in '19960422' format and I need to convert it in '04/22/1996'.

Thanks,
markus

welcome aboard Markus,
DS has ICONV/OCONV functions. If you go to help and read about those functions, you will see that they provide a variety of conversions.
Even one that supports your needs

Do substring an concatinate in derivation

'19960422' [5,2]:'/':'19960422' [7,2]:'/':'19960422' [1,4] = '04/22/1996'

What srimitta says is a good answer but also use trim befor u use a substring, instead i would use iconv and oconv.

markus wrote:Hi All,

I have date in '19960422' format and I need to convert it in '04/22/1996'.

Thanks,
markus

hi all,
how to use iconv and oconv converting dates

use this

Try the following, should be pretty close to what you want:
Ogmios

Markus, in case you are confused, the plethora of answers results from the fact that DataStage server edition does not have data type restrictions. So some of the answers use substring and concatenation techniques (OK if you can guarantee that your dates are always YYYYMMDD format), others use date conversion functions Iconv() and Oconv() which allow for some flexibility in handling dates (for example dates with only two digit year). I would use "DYMD" asserts that the incoming date is in year-month-day order but nothing more. "D/MDY[4,2,2]" very specifically states that the output date (string) will be in month day year order with exactly two digits for month and day, and exactly four digits for year.