+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Programmers Gateway (https://lckb.dev/forum/forumdisplay.php?fid=196)
+---- Forum: Coders Talk (https://lckb.dev/forum/forumdisplay.php?fid=192)
+---- Thread: Unable to convert MySQL date/time value to System.DateTime (/showthread.php?tid=2010)
- Paramount - 08-05-2013
Hello! This is mine code:
{
"server=",
this.textBox_host.Text,
";User id=",
this.textBox_user.Text,
";Password=",
this.textBox_password.Text,
";database=" ,
this.textBox_db3.Text
});
I guess the problem could be in createtime table, because it has datatime is null (0000-00-00 00:00)
Any idea how to fix this problem?
- Wizatek - 08-05-2013
Yes that is a problem, and there isnt much u can do about this because the mysql connector recognises this as invalid and will throw a exception.
The only thing u can do is change the database to have a valid datetime in thet field
- Paramount - 08-05-2013
Yep, but I have found something:
convert zero datetime=True
Do you know where to paste it, and is it possible?
Thanks in advanced!