Set UK date format for SQL Express

Question

Hi,

How do I permanently set the date format for SQL Express to be UK format (dd/mm/yyyy).

I know I can use SET DATEFORMAT DMY, but this only works for that connection.

I have also seen,

exec sp_addlanguage 'British', 'English', 'January,February,March,April,May,June,July,August,September,October, November,December', 
'Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec', 'Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday'
,dmy,1

sp_configure 'default language', 1

reconfigure with override

but, this doesn't seem to work with SQL Express (I get, Could not find stored procedure 'sp_addlanguage'.).

Cheers

Answer 1

You have to set language using sp_configure

EXEC sp_configure 'default language', '23' -- british_english ?
GO
RECONFIGURE;

Edit: need to use code from sys.syslanguages as mentioned

However, default langauge will also need changed for all logins. Hence @@langage showing us_english.