Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    19

    Unanswered: Comparing dates and times

    Hi

    I have a field called last_upd (last updated), and i only want to include records if they have been updated in the past day (24 hours)

    What is the easiest way to work with and compare full datetimes?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    where last_upd > current timestamp - 24 hours
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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