Set Monday is first day of week

Question

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 1

You can use

SET DATEFIRST { number }

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

• SET DATEFIRST (Transact-SQL) - Microsoft SQL Server Docs