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
rklebanov
Charter Member
Charter Member
Posts: 1
Joined: Mon Dec 12, 2005 5:12 pm

date conversion

Post by rklebanov »

I have a string like this "2004.SEP.15"
Need to transform into string "20050915"

Prompt response is appreciated. I am new with iconv, oconv.

Thanks, KK
Top
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:
Contact kcbland

Post by kcbland »

CHANGE(OCONV(ICONV(yourdate, "D"), "D-YMD[4,2,2]"),"-", "")
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Top
Post Reply

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