WeekNumber to start of week date - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: WeekNumber to start of week date

  1. #11
    Join Date
    Dec 2007
    Posts
    82
    ..

  2. #12
    Join Date
    Dec 2007
    Posts
    82
    yes. exactly correct.

  3. #13
    Join Date
    Jun 2014
    Posts
    1
    Dears,
    This is an old one, I know. But still I got some questions around it.
    All the queries do use a date, either hardcoded or sysdate to do this calculation but, what if you do not have that ?
    How can you do this if you have only a year and weeknumber, both in ISO-standard format (iyyy, iw)
    How can you get the first day of the week let's say for 2015 01 (remember ISO-standard iyyy iw)
    How can you get this one done with plain sql ?

    Greetings, Patrick

    P.S.: the answer should be : monday 29/12/2014

Posting Permissions

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



Click Here to Expand Forum to Full Width