I have installed SQL server 2005 developer edition.When trying to insert a date in the UK format '16/04/2007' I get the following error...
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value
if I change the date to be inserted to an American format then I am able to insert it.
I don't want to change the sql as this is something that has always worked - but not with my local install of sql server.
other info that may be of relevance...
My regional settings are all set to UK and this has been applied to the default profile
The server & database collation is Latin1_General_CI_AS
If I attach this database to another instance of sql server installed on a another machine then the insert works.
My pc is a Dell XP Professional SP2
What I don't want to do is write more TSQL but change settings that can alter the behaviour.
any/all help is appreciated!
chris
Chris,
See your other post in Transact-SQL for responses.
Often, the quality of the responses received is related to our ability to ‘bounce’ ideas off of each other. In the future, to make it easier for us to offer you assistance, and to prevent folks from wasting time on already answered questions, please don't post to multiple newsgroups. Choose the one that best fits your question and post there. Only post to another newsgroup if you get no answer in a day or two (or if you accidentally posted to the wrong newsgroup –and you indicate that you've already posted elsewhere).
Thanks for your reply
If you read my other post I realise that I have posted in the wrong forum and I clearly state that! as I do not want a TSQL solution.
hence I posted here afterwards
but thank you for your help
Oh and this has not been answered so all constructive help is still appreciated
thanks
chris
|||Ok one of my colleagues has fixed it.
It turns out that us guys in England don't speak English - we speak British English?
thanks
chris
No comments:
Post a Comment