start date and end date of a week sql server 2005

Question

Possible Duplicate:
Get dates from week number in T-SQL

Hi,

How do I get the startdate and end date for a given week number?

"select getstartdate(weeknumber)" should give the startdate of the given week.

Thanks, Subrat

Possible duplicate: http://stackoverflow.com/questions/607817/get-dates-from-week-number-in-t-sql — Nils Magne Lunde, Apr 06 '11 at 05:46
i want the startdate end end dtae based on 'week number' not date. — subs, Apr 06 '11 at 05:54

score 0 · Answer 1 · answered Apr 06 '11 at 05:57

0

You could have a look at this thread about the topic.

answered Apr 06 '11 at 05:57

Nils Magne Lunde

1,794
1
13
21

score 0 · Answer 2 · answered Apr 06 '11 at 15:18

Typically (on countries like Sweden for example) week one will start on a Monday, so week 1 starts on 3rd Jan in 2011. So you are going to need to specify the year as well.

See here for a list of week start days http://www.timeanddate.com/calendar/?year=2011&country=21

start date and end date of a week sql server 2005

2 Answers2