Using CurrentTimestamp() Function

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
srini.dw
Premium Member
Premium Member
Posts: 186
Joined: Fri Aug 18, 2006 1:59 am
Location: Chennai

Using CurrentTimestamp() Function

Post by srini.dw »

Using CurrentTimestamp() Function i am getting output like
2007-06-25 10:37:14

But i need to Populate this type of fotmat : 20070625 10:37:14 .How to get this format.

Thanks
Top
kris007
Charter Member
Charter Member
Posts: 1102
Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI

Post by kris007 »

This should help:

Code: Select all

Trim(CurrentTimeStamp(),"-","A")
Kris

Where's the "Any" key?-Homer Simpson
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 »

You may need to convert to String before applying a Trim() function.
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)”