Calculates the 2nd day of the week on which the given date (Sunday is the first day) SQL statement

Calculates the 2nd day of the week on which the given date is located (Sunday is the first day)

DECLARE @date datetime
Set @date = GETDATE ()
--Train of thought: current date + Monday (2nd day of the week) and the difference between the current date and the number of days
The return value of--datepart (weekday,date) is related to @ @datefirst
Set Datefirst 7-or set to American English set language us_english; (Sunday is the first day)
Select DATEADD (Day,2-datepart (Weekday, @date), @date) as ' The next day of the week, Monday '
--Monday, independent of SQL Server language version or @ @datefirst
-' 1900-01-01 ' is Monday, ' 1900-01-01 ' plus (current date vs. 1900-01-01 week) Week
Select DATEADD (Week,datediff (week,0, @date), 0) as ' The Week of Monday '
Go