set datefirst 7 SELECT DATEPART(wk, '2001-01-13') AS 'Month Number' set datefirst 2 SELECT DATEPART(wk, '2001-01-13') AS 'Month Number' Month Number ------------ 2Month Number ------------ 3
shan1119兄的方法可以,但是我在查询表的时候这样做就不行了, 比如 set datefirst 7 select top 10 date, DATEPART(wk, ac_paydate) from a where date='2010-1-13' 它显示的还是第3周的呀,
-----------
4(所影响的行数为 1 行)
SELECT DATEPART(wk, '2001-01-13') AS 'Month Number'
set datefirst 2
SELECT DATEPART(wk, '2001-01-13') AS 'Month Number'
Month Number
------------
2Month Number
------------
3
shan1119兄的方法可以,但是我在查询表的时候这样做就不行了,
比如
set datefirst 7
select top 10
date,
DATEPART(wk, ac_paydate)
from a
where date='2010-1-13'
它显示的还是第3周的呀,
select DATENAME ( WK, '2010-01-19' )
-----------
3(所影响的行数为 1 行)
------------------------------
4(所影响的行数为 1 行)是第三周呀