How to get difference time between start_time and end_time

deesh · Post by **deesh** » Mon Jun 30, 2008 7:14 am

Hi Friends,

Can give me the suggestion (logic) how to find difference time between start_time and end_time. I am tried one logic in oracle its giving good results but when i am trying in DataStage its not working. Once again i am requesting friends can give suggestion on this issue

Example:

end_time - Start_time = diff_time

this logic working in Oracle not in DS
if you people know about the solvation of this issue can suggest to me.

ArndW · Post by **ArndW** » Mon Jun 30, 2008 8:21 am

It depends on what format your start_time and end_time are. The typical formats are String and TimeStamp. In either case you can convert this to seconds and can compute the mathematical delta in seconds. Or you can do this directly between two TimeStamps and get a delta in TimeStamp format.