How to get difference time between start_time and end_time
Posted: 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.
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.