Results 1 to 2 of 2

Thread: sysdate

  1. #1
    Join Date
    Jan 2004
    Location
    ny
    Posts
    16

    Unanswered: sysdate

    Hello, I need to get a difference in a table data within one week period.

    Before I was creating a temp table every friday and then following week I run difference , but is there a way to do it without a temp tlb , based on a dates?

    Select dateentr, datechng, p_name
    from pt
    whre (dateentr = sysdate
    or
    dateentr < = (select ((sysdate) - 7)
    from dual))
    and datechng = (select ((sysdate) - 7) from dual)

    Not sure if correct


    Thank you


    Igoremi

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    HUH?

    Select dateentr, datechng, p_name
    from pt
    where dateentr > trunc(sysdate)-8
    or datechng > trunc(sysdate)-8;

    What temp table are you talking about?

Posting Permissions

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