Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: server configuration for Date formats

    Hi,

    I'm using 2 DB servers, with MS SQL Server 2000 on each of them, one for development and one for production.

    When I want to query some information, filtered on a date in the WHERE clause, I have to use DATE = '<MM/DD/YYYY>' on the development machine, and DATE = '<DD/MM/YYYY>' on the production one, to get the result I want, and I can't figure out why (I'm just a lambda user). I would like to configure the servers so that both use the <DD/MM/YYYY> format.

    Could somebody help me on this case ?

    Thanks in advance...

  2. #2
    Join Date
    Dec 2003
    Posts
    454
    Were both fields set to DATETIME datatype?

  3. #3
    Join Date
    Jan 2004
    Posts
    2
    Originally posted by gyuan
    Were both fields set to DATETIME datatype?
    Yes, it is indeed a DATETIME field, and both DB's structure are identical (except data of course)

Posting Permissions

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