Post reply

DateTime format in database changed between 2005 and 2014

  • April 21, 2018 at 7:30 am

    #330516

    I have a 2005 Express instance and a new 2014 Express instance.
    If I recover a FULL backup of a database from 2005 to 2014 the dates in the database are represented differently.

    e.g. 2005 date is 07/06/2019 00:00:00, same row date in 2014 restored data is 2019-06-07 00:00:00

    Should I use a different recovery method/parameters?. Do I need to change language settings on either the 2014 server instance or database?

    Mike

  • April 21, 2018 at 8:53 am

    #1987785

    I've fixed this myself
    both SQL Server Logins used in the ASP.NET app on the 2005 system had a default language of ENGLISH whereas the 2014 logins I had set up with a Default Language of BRITISH ENGLISH

    If I amended the 2014 SQL Logins to ENGLISH everything works once again
    Cheers
    Mike

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply