Need to find elapsed time from start time and end time

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
manu.dwhds
Participant
Posts: 30
Joined: Fri Sep 26, 2008 9:33 pm
Location: Bangalore

Need to find elapsed time from start time and end time

Post by manu.dwhds »

Dear Experts ,

Could you please suggest me a function in transformer to find diffrence between start time and end time as elasped time .

For Example :
Column A Column B Completion Time
18/04/2013 8:54:09 18/04/2013 8:55:35 00:01:26

I need to find the completion time in trasformer .

Timely help is much more appreciated .

Thanks ,
Manu
Manu
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 »

SecondsSinceFromTimestamp()
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
manu.dwhds
Participant
Posts: 30
Joined: Fri Sep 26, 2008 9:33 pm
Location: Bangalore

Issue Resolved

Post by manu.dwhds »

Thank you Ray for quick reply .
Manu
Top
Post Reply

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