Thanks a lot!
Both kinds of solution work fine!
Alessio
----- Original Message -----
From:
To:
Sent: Friday, September 14, 2001 11:09 AM
Subject: RE: Date conversion
> Strictly, you dont need that last , the following should be enough
> since only 2 separators need to be defined (or undefined in this
> case!), between Y & M and between M & D:-
>
> Ans = Oconv(@DATE, "DYMD[4,2,2")
>
> > -----Original Message-----
> > From:
chris.thornton@ascentialsoftware.com
> > [mailto:
chris.thornton@ascentialsoftware.com]
> > Sent: Friday, September 14, 2001 9:20 AM
> > To:
datastage-users@oliver.com
> > Subject: RE: Date conversion
> >
> >
> >
> >
> > How about:
> >
> > Ans = Oconv(@DATE, "DYMD[4,2,2]")
> >
> > Regards
> >
> > - Chris Thornton
> >
> > -----Original Message-----
> > From: Alessio Giordani [mailto:
alessio.giordani@inwind.it]
> > Sent: 14 September 2001 08:59
> > To:
datastage-users@oliver.com
> > Subject: Date conversion
> >
> >
> > Hi all,
> >
> > I have to convert internal date (@DATE) in YYYYMMDD. I tried Oconv
> > function in this way:
> >
> > Ans = Oconv(@DATE, "DYMD[4,2,2]")
> >
> > but the deault separation character (blank) betwen year month and
> > day, produce the following result:
> >
> > YYYY MM DD
> >
> > My rough solution was to replace blanks with ""
![Sad :-(](./images/smilies/icon_sad.gif)
> >
> > Ans = Ereplace(Oconv(@DATE, "DYMD[4,2,2]"), " ", "")
> >
> > Does exist a better way to obtain this result (ex. a correct
> > format string
> > as Oconv argument)?
> >
> >
> > Thanks,
> >
> >
> >
> > Alessio
> >
>