Date Time Error: The conversion of varchar datatype to a datetime datatype resulted in a out-of -range values after deployment in ASP.Net

Question

HiiiI have deployed a website clients machine where server and client are sameBut on that machine  i am getting error like The conversion of varchar datatype to a datetime datatype resulted in a outof range valuesBut the same programs runs on my machine works very fine

dharmendr · Accepted Answer

Hi  Amol111In the client machine datetime format is different So the error1 Change the datetime format of your server fromControl Panel gt Regional and Language Options gt Advanced2 Open IIS and follow below steps Click on you Website Select NET GLOBALIZATION option From Culture tab select required Culture and UI Culture Finally iisreset

Amol111 · Answer

Hii sirAfter changing culture it consides dates like belowif 2102017 2nd Oct 2017 in database it reads like 10022017 10th Feb 2017Problem solved after changing culter to enUS in iis

Date Time Error: The conversion of varchar datatype to a datetime datatype resulted in a out-of -range values after deployment in ASP.Net

Company

Explore

Follow us

Contact Us