Setting the Server DateTime Format 1

[Lekar]

I want to set the datetime format of the server. I tried using SET DATEFORMAT, but it only worked in the current session.
Is it possible to change the default datetime format of the server?

Thanks.

Lenin.

 

[mrdenny]

The datetime format is pulled through the Collation Setting on the server. You can set it on a database using the alter database command. Changing it on the server requires a reinstall I believe.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[Lekar]

Thanks. I'll reinstall SQL Server.

Lenin.