Giveaways, Technology, Smartphones, Programming and Internet


The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

SQL-Error-varchar-datetime

When I executed a query on my website it threw the following exception

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. The statement has been terminated. The statement has been terminated.

I tried the same query on the SQL server management studio, and it was working fine. So after a search I found this article, which says the default language of the user is causing the problem. So I changed it from British English to English.

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

It worked fine Smile

Related Posts

blog comments powered by Disqus