Time stamp conversion

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
saikiran
Premium Member
Premium Member
Posts: 18
Joined: Wed Aug 20, 2008 11:28 pm

Time stamp conversion

Post by saikiran »

Please can any one suggest how to convert a time stamp to CCYYMMDD and MMDDCCYY formats
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

TiimestampToDate() function with appropriate timestamp format string in a Transformer stage.

date_from_timestamp() function with appropriate timestamp format string in a Modify stage.

Dates themselves do not have a format, so the format only becomes pertinent if you then want to convert the date data type into a string data type.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply