August 10, 2010 at 3:26 am
Hi, we've upgraded from MS SQL Server 2005 to 2008 and are having problems
with how dates are being interpreted. For example, the following code
worked perfectly in 2005:
"AND <Column Name of Datetime datatype > '2010-01-01'"
But in 2008, the same line of code does not work and complains that the
nvarchar datatype is not being recognised and needs to be converted.
The issue with this error is that we may have to re-code all stored
procedures and views were a datetime parameter is used to reference a
datetime column, and we have many!!!
The system configuration for the date format for the databases are exactly
the same as they were for 2005.
I'll appreicate any help with this.
Thanks!
August 26, 2010 at 11:35 pm
Could you post the actual code and the exact error message you are getting, please.
August 27, 2010 at 8:54 am
Have you checked DEFAULT LANGUAGE for the connection/login running this query?
August 27, 2010 at 8:57 am
Yes, we checked that and it's set to the UK, which is what we want.
August 27, 2010 at 8:59 am
Can you post table definitions, sample data, and query?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply