Post reply

[SQLSERVER 2000] modify the datetime format parame

  • January 15, 2003 at 9:24 am

    #58665

    Hi,

    where can I change the datetime format parameter in SQL SERVER 2000 and which role must I have do to it.

    Thanks by advance.

    Frensh user.

  • January 15, 2003 at 9:40 am

    #446386

    You can do that at the server level. In this case it will be valid for everybody by using EM there right click your server->Proprieties->Server Settings->Default language for user.

    You have to be sysadmin for this

    Or at the connection level you just put:

    SET DATEFORMAT dmy

    SET DATEFORMAT permissions default to all users.



    Bye
    Gabor

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply