date conversion problem

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
raji
Participant
Posts: 40
Joined: Tue May 16, 2006 6:06 am

date conversion problem

Post by raji »

Hi all, :)

I have to convert the date format "yyyy-mm-dd" to "dd-mon-yyyy"

where my job looks like


SEQ.FILE----- TRANSFORMER STAGE----- SEQ.FILE

Please anybody help me out.

Thanks in advance :)
Raji

Nothing is impossible because impossible itself
says I'm Possible
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

Moderator - please remove this duplicate
Top
Dharma
Participant
Posts: 3
Joined: Fri Apr 14, 2006 8:46 am

Re: date conversion problem

Post by Dharma »

Hi

oconv(iconv(input_col,'D-YMD[4,2,2]),'D-YMD[2,A3,4]')

Dharma.

raji wrote:Hi all, :)

I have to convert the date format "yyyy-mm-dd" to "dd-mon-yyyy"

where my job looks like


SEQ.FILE----- TRANSFORMER STAGE----- SEQ.FILE

Please anybody help me out.

Thanks in advance :)
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”