Hi all,
I have two date columns in source file in timestamp format CALL_START_TIME and CALL_END_TIME. Here i need to pick only a record that has maximum call duration i.e. difference between Call_END_TIME(HH:MM:SS) and CALL_START_TIME(HH:MM:SS).So here i can skip date part,but is there any function in datastage 7.5.3 ,so that i can get the time difference.??
Max duration logic...
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: