Different DATEPART results

[NickCorlett]

I have two servers both running SQL2000 SP3a one server is Windows 2000 and the other Windows 2003.

I am getting different results when attempting to identify days of the week, one says that Saturday is the 6th day whilst the other says it's the 7th.

I think this is something to do with language or country settings but I am unable to find which setting in particular.

 

[gmmastros]

SQL Server has a DateFirst setting.

On each server, run the following...

Select @@DateFirst

Also, take a look at this...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_set-set_4qic.asp

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[NickCorlett]

George,

Thanks for the reply, I have been on annual leave.

If I run SELECT @@DATEFIRST on both servers, one gives me 1 the other gives me 7.

If I use the SET DATEFIRST 1 option on the failing server this only corrects the problem for this connection.

I have done some investigation and I have ensured that the Default Language for user is "British English" which should mean that Monday is returned as the first day, however this is not the case!

Any advice would be appreciated.

Cheers