ERROR: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

Hi *.*,

Yet another common error while handling with datetime in sql.Worst part of this error is on code side and sql site we had given datetime as datatype.Still its their !!!!

Solution:

1. changing the default language for the SQL user.(default Language as ‘English’) More refer:

2.Use Convert convert(datetime,'23/11/2011',105)

If u had any trouble just ask, Happy to help u :)

Stay Tune... 

Have a nice day... 'N happy Coding :)