How to convert months into weeks?

  1. js98

    js98 Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    usa
    I have to split the first three months of the year. All weeks should end on Friday and begin on Saturday.

    Can anyone please guide me as to how I can accomplish this task? I appreciate the help.

    Thanks
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,750
    Likes Received:
    382
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    This blog post describes how the two week numbering conventions in Oracle are defined, along with some other interesting information:

    That Was The Week That Wasn’t

    No week ends on Friday in either convention. The day numbers start with 1 (Sunday) and end on 7 (Saturday), thus 6 will be Friday. You can write a function to return your definition of week number where your week starts on Saturday (7) but be prepared for partial or missing week numbers for incomplete weeks (as when January 1 falls on Wednesday).