Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    9

    Unanswered: Changing Language Settings

    Hi,

    I was wondering how to change the language settings on SQL Server. The server is currently set to US English, and I was wondering how it is possible to change it to UK English. The Server Regional Settings are set to UK English.

    Also, on a semi-related topic, does SQL Server store dates in a universal format, and then when data is requested does it 'translate' these dates into the format required by that particular regional setting?

    Thank you for any input

    Marman

  2. #2
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    Not sure on the first question, but as far as dates are concerned, yes, they are stored in , I believe, integer format, and converted to whatever date format 1) you client uses, or 2) you ask for via CONVERT statement.
    -bpd

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •