SQL – Changing to British Datetime format

Error converting data type varchar to datetime
Are you getting the above error?

Run the following under your app user.

select @@Language, @@Langid

If it says us_english then you’re probably hitting errors when parsing dates as DD/MM/YYYY.
We can change the default language for a particular user. Login to your SQL server as an administrator account and run the following;

ALTER LOGIN yourapplogin WITH DEFAULT_LANGUAGE = British;
GO

Then login with the user “yourapplogin” and run

select @@Language, @@Langid

Hopefully you now see “British” and 23.

No related posts.

4 Responses to “SQL – Changing to British Datetime format”

1. nike air max says:

   April 28, 2011 at 4:48 pm

   Great article, I think you covered everything there.
2. new era hats says:

   June 2, 2011 at 12:46 pm

   Great article, I think you covered everything there.
3. baseball hats says:

   June 9, 2011 at 7:27 pm

   Great article, I think you covered everything there.
4. columbia jackets says:

   September 26, 2011 at 4:52 pm

   http://www.columbiaoutlet.net/
   Was kind of worried about the color being white but it wears well.