使用T-SQL获取下个月的第一个星期日

试试这个：

Declare @D Datetime Set @D = [Some date for which you want the following months' first sunday]Select DateAdd(day, (8-DatePart(weekday,     DateAdd(Month, 1+DateDiff(Month, 0, @D), 0)))%7,     DateAdd(Month, 1+DateDiff(Month, 0, @D), 0))

编辑说明：

下个月的第一个月由以下表达式给出：

DateAdd(Month, 1+DateDiff(Month, 0, @D), 0)

或方式：将1更改为2，可以将其修改为从现在起两个月的第一个月：

DateAdd(Month, 2+DateDiff(Month, 0, @D), 0)

编辑：作为对@NissanFan和@Anthony的响应：将其修改为返回第一个星期一，星期二，星期三，等等，将值8更改为9、10、11等。

Declare @Sun TinyInt Set @Sun = 8Declare @Mon TinyInt Set @Mon = 9Declare @Tue TinyInt Set @Tue = 10Declare @Wed TinyInt Set @Wed = 11Declare @Thu TinyInt Set @Thu = 12Declare @Fri TinyInt Set @Fri = 13Declare @Sat TinyInt Set @Sat = 14Declare @D Datetime, @FONM DateTime -- FirstofNextMonth Set @D = [Some date for which you want the following months' first sunday]Set @FONM = DateAdd(Month, 1+DateDiff(Month, 0, @D),0)Select   DateAdd(day, (@Sun -DatePart(weekday, @FONM))%7, @FONM) firstSunInNextMonth,  DateAdd(day, (@Mon -DatePart(weekday, @FONM))%7, @FONM) firstMonInNextMonth,  DateAdd(day, (@Tue -DatePart(weekday, @FONM))%7, @FONM) firstTueInNextMonth,  DateAdd(day, (@Wed -DatePart(weekday, @FONM))%7, @FONM) firstWedInNextMonth,  DateAdd(day, (@Thu -DatePart(weekday, @FONM))%7, @FONM) firstThuInNextMonth,  DateAdd(day, (@Fri -DatePart(weekday, @FONM))%7, @FONM) firstFriInNextMonth,  DateAdd(day, (@Sat -DatePart(weekday, @FONM))%7, @FONM) firstSatInNextMonth