如何在SQL Server中获得上周的第一天和第六天 [英] How to get first and Sixth day of previous week in sql server

问题描述

大家好，

我想在上周的sql server中获得第二天和第六天.

第二天是星期一"，第六天是星期六".



谢谢与问候

Mohd wasif

Hi All,

I want to get Second and Sixth Day of a previous week in sql server.

Here Second Day is "Monday" and Sixth Day is "Saturday".



thanks & regards

Mohd wasif

推荐答案

HI Mohd wasif
请参考

HI Mohd wasif
please refer
http://forums.asp.net/t/1764334.aspx/1?How+to+get+First+week+start+date+end+date+Second+Week+start+date+end+date+and+so+on+[^]


It will help you to get the all the day month year that you want

Regards
Deepak

在几分钟前只有同样的问题，请参阅:
如何获取第一天和第六天前一周在sql server中 [

few minutes before only got the same question ,refer:
How to get first and Sixth day of previous week in sql server[^]

这篇关于如何在SQL Server中获得上周的第一天和第六天的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！