sql server 2005 express DateTime format changes at various installation type.


  • Hello,
    When I install sqlserver express by clicking its icon its date time format suitable with my computer and no problem. (day/month/year).
    But when I install it with my software deployment as a prerequisite I use command line argumens like this:

    sqlexpress32 /insancename=myinstance ......

    its installs DateTime format different type(month/day/year) and this causes error in my application.
    Is there any way to determine DateTime format in install process or  do a have to change this manually inside
    the sql server express

    thank you.
    Tuesday, December 30, 2008 10:05 AM

All replies

    There might be other ways to control this also, here is one way.

    SP_CONFIGURE 'default language'


    SP_DEFAULTLANGUAGE @loginame = 'LoginName', @LANGUAGE = 'Language'

    Or you could use standard ISO dateformats if you can.

    Sankar Reddy | |
    • Edited by Sankar Reddy Tuesday, December 30, 2008 10:43 AM Add ISO info
    Tuesday, December 30, 2008 10:41 AM
  • hi,
    just a little addendum to Sankar...
    actually you should alway use the ISO date format to prevent these kinds of problems, as every server principal (login) can have his/her own language setting..
    regards - DbaMgr2k - DbaMgr and further SQL Tools
    Wednesday, December 31, 2008 12:05 PM