set Monday is first day of week

I’m using Microsoft sql server and in the sql server by default first day of week is Sunday but I need to set it Monday is the first day of week.

Answer

You can use

SET DATEFIRST { number }

number
1      Monday
2      Tuesday
3      Wednesday
4      Thursday
5      Friday
6      Saturday
7      Sunday

Here the link to the official docs: https://docs.microsoft.com/en-US/sql/t-sql/statements/set-datefirst-transact-sql?view=sql-server-2017