MSSQL date calculation-end date of this Monday and end date of this week start date of this month and end date of this month

-- The weekday of the day is equal to the actual weekday, so the day minus the day can get the correct number of weeks.

Select datepart (weekday, dateadd (DD,-1, getdate ()))

-- The date of this Monday

Select convert (varchar (10), dateadd (DD,-(datepart (weekday, dateadd (DD,-1, getdate ()-1), getdate ()), 120)

-- The date of this Sunday

Select convert (varchar (10), dateadd (DD, (7-datepart (weekday, dateadd (DD,-1, getdate (), getdate (), 120)

-- Start date of this month

Select convert (varchar (10), dateadd (DD,-datepart (day, dateadd (DD,-1, getdate (), getdate (), 120)

-- Date of the last day of the month

Select convert (varchar (10), dateadd (DD,-datepart (day, dateadd (mm, 1, getdate (), dateadd (mm, 1, getdate (), 120)