The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
this problem in asp.net please help me for solve
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Bharathi RajaPosted Jan 31, 2018, 5:12 AM
Nitin SontakkePosted Jul 14, 2016, 2:20 AM
Nilesh SawardekarPosted Jul 13, 2016, 2:06 PM
The problem is with the time zone setting. Specify in other formats like mm/dd/yyyy (usually works).
Specifying the date as 30/12/2013 resulted in the error for me. However, specifying it as mm/dd/yyyy format worked.
If you need to convert your input the you can try looking into the
CONVERTmethod. Syntax isCONVERT(VARCHAR,@your_date_Value,103)CONVERT(VARCHAR, '12/30/2013', 103)The finishing 103 is the datetime format.
Refer this link for conversion formats and further reading.http://www.w3schools.com/sql/func_convert.asp