Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2011
    Posts
    82

    Unanswered: Start Of Week Of Current Quarter

    Hello

    I am trying to achieve the criteria for the Start Of Week for the current quarter

    The following syntex returns the start of the current week
    select next_day( trunc(sysdate) - interval '6' day, 'MON') from dual

    The following syntex returns the start of the current quarter
    select TRUNC(SYSDATE, 'Q') FROM DUAL;

    If someone could kindly help me achieve the start of the week for the current quarter, then your help would be greatly appreciated

    Kind Regards
    Helen

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    See my reply to this question in the Microsoft SQL Forum to get a bit more background that you need to provide in order for us to help you with this question.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    if

    select next_day( trunc(sysdate) - interval '6' day, 'MON') from dual

    returns the monday of the current week. WHat would you replace trunc(sysdate) with to find the monday of the current quarter?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Just be careful how you construct the query. The correct answers for this question in North America, Europe, and the Middle East are all different and require different code.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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