开发者

How do I define a work week in SQL Server 2000?

I need to split a report by work week, and our work week is Saturday through Friday. How would I convert an ISO week from DATEPART(WW, ) into a work week开发者_如何转开发?


Use SET DATEFIRST to be saturday:

SET DATEFIRST 6;

Check the DATEPART documentation regarding the ISO week for how this affects things.


SET DATEFIRST 6

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜