yyyy-mm-dd TO MMYYYY DATASTAGE

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
sunnymdatastage
Premium Member
Premium Member
Posts: 19
Joined: Tue Jul 16, 2013 10:21 am

yyyy-mm-dd TO MMYYYY DATASTAGE

Post by sunnymdatastage »

How can I convert yyyy-mm-dd TO MMYYYY in DATASTAGE??
sunnym
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Are both fields strings?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
sunnymdatastage
Premium Member
Premium Member
Posts: 19
Joined: Tue Jul 16, 2013 10:21 am

Post by sunnymdatastage »

Input is Date.
sunnym
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Dates have no formats, only strings do. Use DateToString() with a format mask that matches your desired output.
-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)”