Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2008
    Posts
    26

    Question Unanswered: Getting current week based on week number

    Hi Guys,

    Actually im trying to get the current week using the week number.

    Currently this gives me the "Current Week"

    From: TRUNC(SYSDATE,'IW')
    To : TRUNC(TO_DATE(SYSDATE),'IW')+6

    And this is what i do when i try to get the "Prior Week"

    From: TRUNC(SYSDATE,'IW')-7
    To : TRUNC(SYSDATE,'IW')-1


    Im not sure if this will work as for the leap years.

    But is there a way to get the "start week" and "end week" based on week number, just to be on the safe side.

  2. #2
    Join Date
    Nov 2008
    Posts
    26
    hi guys,

    found a useful like, which surprises me about how the "week no" is computed.

  3. #3
    Join Date
    Nov 2008
    Posts
    26
    Quote Originally Posted by ajitpal.s
    hi guys,

    found a useful like, which surprises me about how the "week no" is computed.
    http://rwijk.blogspot.com/2008/01/da...lement-ww.html

Posting Permissions

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