星期计算问题

Question

select datepart(WEEKDAY,'2014-02-27') week 
星期天开始算的 

Answer 1

select datepart(WEEKDAY,'2014-02-27')-1 week

Answer 2

我要周一开始计算的
好吧 用case then

Answer 3

不还意思 
select   case datepart(WEEKDAY,'2014-02-16') -1  when '0' then '7' else  datepart(WEEKDAY,'2014-02-16') -1 end week

Answer 4

找到个更简便的方法：select datename(week,dateadd(day,-1,'2014-02-16'))week

Answer 5

你那个不行测试下这个数据 
select datename(week,dateadd(day,-1,'2014-02-28'))week结果：
week
9