Results 1 to 4 of 4

Thread: Date function

  1. #1
    Join Date
    Mar 2004
    Location
    Ireland
    Posts
    4

    Red face Unanswered: Date function

    Is it possible to do a select query on a date within 1 hour....
    I want to return records that have been updated within the last hour?

    any help would be much appreciated,
    Thanks,
    Brian

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Yes, assuming that every record contains a DATE field
    which records when the record/row gets changed.

  3. #3
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas, USA
    Posts
    68
    SELECT
    FROM
    WHERE UPDATED_DATE>SYSDATE-1/24

  4. #4
    Join Date
    Mar 2004
    Location
    Ireland
    Posts
    4
    thanks lads,
    perfecto

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •