how to reset week start date

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

ChiragNS One Orange Chip Points: 26137 More actions · Answer 1

One Orange Chip

Points: 26137

March 9, 2009 at 12:32 am

SET DATEFIRST 5

"Keep Trying"

karthik M One Orange Chip Points: 29139 More actions · Answer 2

set datefirst 5 will do that.

But it is session based. If you open another session, you can see 7.

karthik

ChiragNS One Orange Chip Points: 26137 More actions · Answer 3

Yes its only for the current session. DateFirst acutally depends on the language chosen. For english it 7 - Sunday.

"Keep Trying"

Sergiy SSC Guru Points: 110208 More actions · Answer 4

Chirag (3/9/2009)
Yes its only for the current session. DateFirst acutally depends on the language chosen. For english it 7 - Sunday.

For English in Australia it's 1 - Monday.

It depends not on language but on chosen locale.

_____________
Code for TallyGenerator

karthik M One Orange Chip Points: 29139 More actions · Answer 5

is there any option to set the datefirst server level instead of sesssion level?

karthik

mike gercevich SSCrazy Points: 2961 More actions · Answer 6

You can set the default language for the server: sp_configure;

or set the accounts default language: ALTER LOGIN SET DEFAULT_LANGUAGE;

or the current process, as seen above.