SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Sep 2002
    Location
    South Africa
    Posts
    27
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    changing date format in SQL Server 2000??

    hi there,

    we're developing an asp application for a database but we keep on getting conflicting dates; on my machine (the server) it is returning US format dates and my colleague's maching is returning UK format dates. We're both accessing the same SQL Server and both of our machines are set on Windows to English - United Kingdom.

    Any help will be appreciated,

    Mina.

  2. #2
    SitePoint Wizard
    Join Date
    Jan 2001
    Location
    Milton Keynes, UK
    Posts
    1,011
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you're using different SQL Server Logins, check that the default language of both Logins is the same. One of you may be using 'English' and the other 'British English'.

    You could change any SQL queries to format the DateTime fields in a particular country's format (see Convert). However, this'll convert the DateTime field value to a character type which is not always desirable.


Bookmarks

Posting Permissions

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