Date conversion

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
dnat
Participant
Posts: 200
Joined: Thu Sep 06, 2007 2:06 am

Date conversion

Post by dnat »

Hi,

I want to output today's date in one of the output column in a sequential file. The output format is mm/dd/yyyy. I am trying this .OConv(@DATE,'D/YMD[2,2,4]'). But it is not working..can anyone help me out.

Thanks
Top
sachin1
Participant
Posts: 325
Joined: Wed May 30, 2007 7:42 am
Location: india

Re: Date conversion

Post by sachin1 »

oconv(@date,"D/MDY[2,2,4]") gives output as 06/12/2008
Top
dnat
Participant
Posts: 200
Joined: Thu Sep 06, 2007 2:06 am

Post by dnat »

Thanks a lot!! and it worked.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”