Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    39

    Unanswered: [6.5] Server language English but date format is Dutch

    I have a Sql 6.5 database-server. When I open a query window and ask for getDate() it returns Tuesday, Sep 30 2003 12:00 AM.

    So far so good.

    However, when I connect through an ASP page on my webserver (through ODBC) and ask for getDate, I get a Dutch format: 30-09-2003.

    My Sql Server is set to default (English US)
    My Database user is set to English Us
    My DB server's regional settings are set to US
    My ODBC is set to use English as a language
    My Webserver's regional settings are set to US (d/M/y)

    I'm at wit's end. I have no clue as to why I am getting Dutch dates. I know I could just convert(varchar,...) but that is not an option right now.

    Thanks in advance,

    Kristof

  2. #2
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    Does sound like a puzzle. What are the Web Clients settngs? Don;t know why that would matter unless you are runing code on the client side, but it's the only thing you don't have listed.
    -bpd

  3. #3
    Join Date
    Sep 2003
    Posts
    39
    The client side is as English (US) as it gets. Regional settings are English etc.

    Glad to see you're puzzled as well ... Little comfort, but comfort

  4. #4
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    As a test, try changing each of the servers' settings, one at a time, to a third setting (no idea off the top of my head what this would be) to see if and when a change occurs.

    This could help give you a new angle (?!).
    -bpd

  5. #5
    Join Date
    Sep 2003
    Posts
    39
    Solved.

    Apparently, you can have multiple regional settings on a server (NT4) and NT decides which one it picks. So I forced US to be the default system locale, booted the (live *glubs*) database server and all was well.

    Thanks a lot for thinking with me!

Posting Permissions

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