March 9, 2012 at 6:18 am
Hello, i wondered if anyone else had experienced this or knows a fix?
I tried to run a query yesterday to find data where date > '2012-01-30'. I have done this thousands of times without an issue. For soem reason i got an error of The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
Changing the date to 2012-30-01 will make the query run and so for some reason the date formats have chanegd to American format. I am teh only memnber of my team who is experiencing this issue- everyone else can run the initial query against the same tables witout a problem. The only thing i can think, is that i had previoulsy rdp'd to my desktop using a laptop and run the sql on there. i have doen this previously with other laptops and not had a problem. I have since done the same thing with the other laptops and it hasn't resolved the issue. I am not sure why this could be the reason but it is the only differnet thing i did.
I have had a look on the web which would suggest that the date format can only be changed at the server level, unless by changing it within the code( which i am not doing!). From the investigation i have done, it would seem that the issue i have is not possible- and yet it is- can anyone help???
Much appreciated
matt
March 9, 2012 at 8:28 am
I assume you are running SSMS on a remote machine and not directly on the server. If so check the regional settings on your machine.
MCITP SQL 2005, MCSA SQL 2012
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply