Change sql sever datetime format settings

hello everybody


I have a problem in setting my sql sever datetime format from
mm/dd/yy to dd/mm/yy so that what ever the data comes inside and go out side is of the forma t and also displayed on web forms in this format only.



By default the sql server is taking US format mm/dd/yy

can any one help me out to configure the seettings


Alok

SET DATEFORMAT mdy
GO
DECLARE @datevar datetime
SET @datevar = '12/31/98'
SELECT @datevar
GO

SET DATEFORMAT ydm
GO
DECLARE @datevar datetime
SET @datevar = '98/31/12'
SELECT @datevar
GO

SET DATEFORMAT ymd
GO
DECLARE @datevar datetime
SET @datevar = '98/12/31'
SELECT @datevar
GO

Example from BOOKS ONLINE