Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. newToOracle

    Query Using Sysdate-1

    Thanks for replying. What I meant is to find all records that failed 5 minutes prior to the current sysdate?
  2. newToOracle

    Query Using Sysdate-1

    Correction to first posted message. Please ignore that one. On the same note, how would you format an sql to find all records where the last_fail_time which is a DATE field is 5 minutes less then the current sysdate? select * from foo.bar...
  3. newToOracle

    Query Using Sysdate-1

    On the same note, how would you format an sql to find all records where the last_fail_time which is a DATE field is less then the current sysdate? select * from foo.bar where foo.last_fail_time < ???????;

Part and Inventory Search

Back
Top