want to convert ddmmyyyy into yyyymmdd in parallel ex. 8.x

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
deesh
Participant
Posts: 193
Joined: Mon Oct 08, 2007 2:57 am

want to convert ddmmyyyy into yyyymmdd in parallel ex. 8.x

Post by deesh »

Hi all

Help me how to convert ddmmyyyy into yyyymmdd in parallel ex. 8.x
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Since they're just character strings, substring. Or take the long way home and use StringToDate() followed by DateToString() with appropriate masks.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

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