Declare @ date & nbsp; datetimeset @ dategetdate (): Current date + Monday (2nd days per week) the number of days difference from the current date -- datepart (weekday, date) the returned value is related to @ datefirst setdatefirst7 -- or set it to the American English setlanguage to calculate the 2nd day of the week of the given date (Sunday is the first day)
Declare @ date datetime
Set @ date = getdate ()
-- Train of thought: the number of days between the current date + Monday (2nd days per week) and the current date
-- The return value of datepart (weekday, date) is related to @ datefirst.
Set datefirst 7 -- or set it to set language us_english; (Sunday is the First Day)
Select dateadd (day, 2-datepart (weekday, @ date), @ date) as 'Day of the week, Monday'
-- Monday is irrelevant to the SQL server language version or @ datefirst
-- '2014-01-01 'is Monday, '2014-01-01' plus (number of weeks between the current date and)
Select dateadd (week, datediff (week, 0, @ date), 0) as 'Monday of the week'
Go