April 1, 2008 at 5:39 am
Just noticed 2 of our servers, supposedly identical, get different results with a date query.
Its a simple select where date = '30/06/08'
In that format one server returns the resultset. The other errors with the old "conversion of char data type to smalldatetime out of range".
Which server setting would cause this variation?
April 2, 2008 at 10:55 am
Have you checked the 'Regional and Language' options in 'Control Panel' on both machines to see if they are the same?
April 2, 2008 at 3:30 pm
Yeah they are. I'm really confused!
April 2, 2008 at 4:21 pm
Try running the script below on both machines and comparing the outputs of both to see if they are the same (lists all server configuration options):
USE master
EXEC sp_configure 'show advanced option', '1'
GO
RECONFIGURE
EXEC sp_configure
GO
April 2, 2008 at 6:03 pm
Can try to format it instead of depend on Reginonal Setting or Server configuration?
http://sqlserver2000.databases.aspfaq.com/can-i-make-sql-server-format-dates-and-times-for-me.html
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply