Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Session language

Author  Topic  srad Starting Member 39 Posts Posted - 2001-10-04 : 04:52:13 The current language on our server (sql2k ent) is us_english. This is returning date in mdy format but some of the development team want this changed to dmy. I suggested running set language N'British' which succssesfully runs in query analyzer but when i exec select getdate() to test the changes the date is still returned in yyyy mm dd format. Why?