SELECT DATEPART( wk, GETDATE())
However, to determine the current week in a month, use this query written by AMB
select datediff(week, convert(varchar(6), getdate(), 112) + '01', getdate()) + 1
returns 5 as the date today is 24 December 2007
Did you like this post?
|subscribe via rss||subscribe via e-mail|
|print this post||follow me on twitter|