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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER