Reputation: 750

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.

Upvotes: 4

Answers (4)

Reputation: 844

You can use

SET DATEFIRST { number }

Upvotes: 4

Reputation: 492

This sets the first day of the week to Monday

SET DATEFIRST 1;

Upvotes: 4

Reputation: 1626

Use this command :

SET DATEFIRST 1;

See this post

Upvotes: 2

Reputation: 17943

You can use SET DATEFIRST like following.

SET DATEFIRST 1

You can read more about this here and here

Upvotes: 3