Date Mask

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
kld05
Charter Member
Charter Member
Posts: 36
Joined: Fri Apr 28, 2006 8:12 am

Date Mask

Post by kld05 »

Is there a date format that will handle a string in 1/1/2009 or 01/1/2009 or 1/01/2009 or 01/01/2009 format and return a consitent result of 2009-01-01. Year will always be YYYY but day and month may drop the leading zero (source).
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

No.

Standardize the format of your string (add leading zeroes to month and day) so that you only need one mask.

Search the forum for techniques.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

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