.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani

Home >> Forum >> ASP.Net >> Post New QuestionBookmark and Share Subscribe to Forum

Incorrect date value: '9/8/2009 12:00:00 AM' in mysql

Posted By: archana     Posted Date: January 08, 2010    Points:2   Category :ASP.Net
hi all,

i have a problem in updating user detail
im using mysql db and when retriving the details date:9/8/2009 12:00:00 AM but im inserting date like 2009-09-08


then it shows error like Incorrect date value: '9/8/2009 12:00:00 AM'

Responses
Author: Lalij Mer             
Posted Date: January 08, 2010     Points: 5   

Try to change date and time from control panel

Go->setting->Control Panel->Regional Languages Options->Customize and change date as your requirement.

Thanks,

Please Check my answer if you help....
Thank You...

Lalit.
Author: archana             
Posted Date: January 08, 2010     Points: 5   

still not working...............

Author: Amit Mehra             
Posted Date: January 08, 2010     Points: 5   

Hi,

try like this change you connection string of mySQL database like this

Append Allow Zero Datetime = True; to your connection string

For Eg

<add name="MySqlConnectionString" connectionString="Server=localhost;Database=dbName;Uid=root;Pwd=myPassword  ;Allow Zero Datetime = True;"/>


Thanks
Amit

Thanks,
Amit
Please "Mark As Answer " if this post help you.
Author: archana             
Posted Date: January 08, 2010     Points: 5   

Thank u so much amit mehra its working fine.............



Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend