How do I add UK Dates to SQL Server?

This FAQ shows you how to set SQL Server to allow UK Date format using a simple stored procedure call.

This has been troubling me for ages and I finally found the answer. I know there are a lot of people that had been looking for it too.

If you want to make SQL Server accept UK Dates and Deliver UK dates then you need to excecute a stored procedure. Its very easy to do. Just open you SQL Server query analyser and hook in to your server. Then add this code:

----

EXEC sp_defaultlanguage 'username', 'british'

----

Where "username" is the login you use to access your SQL Server from your ASP pages. Then run your query. If it was succesful you will be informed that the users default language has changed.

If you want to change it back then use:

----

EXEC sp_defaultlanguage 'username', 'us_english'

----

And that will do it.

Nic Skitt

Comments

where exactly

September 13, 2001 by bjorn king

where exactly do I run this query ? In Dreamweaver or in MySQL ? I'm a beginning programmer so could you explain a little bit more clearer to me what to do to set the date to british

Thanks!!!

November 1, 2001 by I'm Quadraman Dammit!

I've been struggling with that one on and off for a week and a half! Worked first time!

RE: where exactly

November 1, 2001 by I'm Quadraman Dammit!

If you're using MySQL, this article isn't for you. Nic forgot to put the word "MicroSlop" in front of SQL Server. If you are using MS SQL Server, then the SQL Query Analyzer is one of the programs that ships with it. You enter the code he mentions in the Query window and then execute it from the Query menu.

Problem with Host

December 20, 2001 by Jack Turnbull

Great tip - works for my development machine, but my internet SQL Server host will not let me alter his application (shared clients)!

See all 6 Comments

You must me logged in to write a comment.