changing date format of sql 2000 without reinstallation

[vikramshenoy]

Hello,
The win 2000 server system has UK date format setting but the sql 2000 installed has United States date format.So how do we change the sql date setting to point to UK (britsh) date setting without reinstallation. I am in a fix and in need of urgent help.

Thanx in advance
Viks

 

[rt63]

U can try this.

EXEC sp_configure 'default language' ,'23'

23 is the language code for British English. Currently your database would be having 0 (which is US English). You can check these values in the following system tables

syscurconfigs
syslanguages

More details available in T-SQL help/BOL


RT

 

[wengyan]

SELECT GETDATE() TODAY,
DATEADD(DAY,-1,DATEADD(month,1,CONVERT(datetime,convert(varchar,datepart(year,GETDATE()))+'-'+convert(varchar,datepart(month,GETDATE()))+'-1')))
AS [The lastest day of month]

TODAY The lastest day of month
------------------------------------------------------ ------------------------------------------------------
2002-09-24 15:06:22.937 2002-09-30 00:00:00.000 WENG YAN

 

[wengyan]

Sorry,I post an mistake thread WENG YAN