Week() function in sql script.

Question

I am using sql server 2005. I just want to know is there something we can get the week number for the particular month. Example Date = '2008-10-16' Is there something we can have SELECT WEEK(Date). Or any better suggestion.

Answer 1

SELECT DATEPART( week, '2008-10-16')

Answer 2

You can do it this way:

SET @weeksinmonth=datediff(week, @date, @lastdate) + 1

That is a copy-and-paste out of one of my stored procedures.

Answer 3

select (datepart(dd,'2008-10-08')-1) / 7 + 1