Link to home
Start Free TrialLog in
Avatar of xbox360dp
xbox360dp

asked on

Help with query for entries that take over 4 mins for the current day.

Gurus,

I need help writing a query that reports all entries that take over 4 mins for the current day.

Current Query:

select tsjkeyi import_id, TSJSTAD start_time, TSJENDD end_time from TSJ
where TSJTYPS = 22
order by TSJSTAD desc;

Result:
import_id   start_time                                               end_time
379324         02-SEP-14 08.25.09.663000000 AM         02-SEP-14 08.31.11.118000000 AM
379316         02-SEP-14 08.23.48.561000000 AM         02-SEP-14 08.23.50.418000000 AM

I just want the record where the total time was over 4 minutes:

import_id   start_time                                               end_time
379324         02-SEP-14 08.25.09.663000000 AM         02-SEP-14 08.31.11.118000000 AM

Thanks in advance!
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of xbox360dp
xbox360dp

ASKER

Perfect!