Recent content by ravensensei

  1. R

    Using NOW() - hours/days in query

    Ack! Didn't realize I could use SYSDATE - 1 to get yesterday.
  2. R

    Using NOW() - hours/days in query

    It does, where can I find the online help tho?
  3. R

    today's date Progress database sql syntax

    can you point me in right direction at this point to that doc, because I can't find it on the current site. I'm trying to run a query, but I want everything from yesterday and I can't figure out how to offset NOW()
  4. R

    Using NOW() - hours/days in query

    I'm trying to write a query that allows me to look at data from the day before. It's a job I'm running at 3am, and I'd like to get all the data from the day before from 12:01am until 11:59 pm. I looked around for documentation, but I can't find any on offsetting NOW().
See more
Back
Top