110,533
社区成员
发帖
与我相关
我的任务
分享
create table tb(日期 datetime)
insert into tb select '2008-06-15'
insert into tb select '2008-06-16'
insert into tb select '2008-06-17'
insert into tb select '2008-06-18'
insert into tb select '2008-06-19'
insert into tb select '2008-06-20'
insert into tb select '2008-06-21'
insert into tb select '2008-06-22'
insert into tb select '2008-06-23'
insert into tb select '2008-06-24'
insert into tb select '2008-06-25'
select *,
日期='第'+ltrim((datepart(dd,日期)-(datepart(dw,日期)+@@datefirst-1)%7)/7)+'周 星期'+replace(ltrim((datepart(dw,日期)+@@datefirst-1)%7),'0','天')
from tb
select datename(weekday,getdate())
select datepart(day,getdate())/7+1