Max duration logic...

[prasson_ibm]

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.??

[ray.wurlod]

SecondsSinceMidnight() [ which may not be the correct name ]

If you apply this function to both times you can subtract to get the interval.