How to set date format to British
hi,
i've been trying set date format in sqlserver 2005 express setting language, using sp_addlanguage article id 173907 have, seems refer sql 2003 , keep getting syntax error in query.
i've been trying set date format in sqlserver 2005 express setting language, using sp_addlanguage article id 173907 have, seems refer sql 2003 , keep getting syntax error in query.
the trick use set language british.
unfortunately checking result select @@language, @@langid shows format still in default seems misleading.
the news use of exec sp_configure 'default language' return correct result language format 23 british.
john
unfortunately checking result select @@language, @@langid shows format still in default seems misleading.
the news use of exec sp_configure 'default language' return correct result language format 23 british.
john
SQL Server > SQL Server Express
Comments
Post a Comment