+ Post New Thread
Results 1 to 2 of 2
Windows Server 2000/2003 Thread, SQL Server Date field issues in Technical; I've got an old SQL 2000 Server which I want to move to a new server, running SQL Express 2005. ...
  1. #1
    Sheridan's Avatar
    Join Date
    Oct 2010
    Posts
    1,388
    Thank Post
    125
    Thanked 97 Times in 66 Posts
    Rep Power
    31

    SQL Server Date field issues

    I've got an old SQL 2000 Server which I want to move to a new server, running SQL Express 2005. I can restore the database to the new server no problems, but all of the date fields in my new database have changed.

    I.e In the old DB, I had a lot of datetime fields with a size of 8 (i.e 01/12/2010) as all that is required is the actual date. Now all of these fields appear as 01/12/2010 00:00:00 and this screws up all of my queries. The size is still showing in the new DB as 8, but its obviously got the time in there as well.

    Am I doing something wrong here, I don't recoding every date reference to cope with this!

  2. #2
    Sheridan's Avatar
    Join Date
    Oct 2010
    Posts
    1,388
    Thank Post
    125
    Thanked 97 Times in 66 Posts
    Rep Power
    31
    Ahhh I've found what was going wrong. The login in the new DB had defaulted to the British English language, on the original the login as English (as in US English) so the queries were coded to suit the US style of reverse dates.

    Setting the Login to English and the queries are working again. Simple fix but an easy one to miss!

    Thanks for the info though - I was hoping I wouldn't have to recode or redesign the tables!



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 5
    Last Post: 21st June 2010, 11:46 AM
  2. SQL memory issues and Reason 0
    By leonard.powers in forum MIS Systems
    Replies: 23
    Last Post: 1st October 2009, 01:58 PM
  3. excel date field to general numbers
    By djones in forum Scripts
    Replies: 3
    Last Post: 4th August 2009, 10:51 AM
  4. Microsoft Access Help! Date Field
    By Pyroman in forum How do you do....it?
    Replies: 1
    Last Post: 2nd May 2008, 04:19 PM
  5. Replies: 4
    Last Post: 17th December 2007, 06:15 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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