Page 2 of 2

Unable to convert MySQL date/time value

Posted: Tue Aug 02, 2011 8:50 am
by davidc
Service release v2.0.7 fixes the Edit Connection problem, but if you set the "Allow Zero DateTime=True" the Date fields will not be displayed correctly. In the next (unreleased) service build (v2.0.8) the DateTime display issue will be resolved. Unfortunately we couldn't get the fix into v2.0.7 in time. David

Unable to convert MySQL date/time value

Posted: Tue Aug 02, 2011 8:54 am
by gkhairallah
Ok. No problem. Thanks for the update. I will wait for release 2.0.8 for the fix regarding the date fields. in the meanwhile, I'll just reformat date fields.
By the way, do you know why a datetime field in MySQL doesn't work, but when connecting to an MSSQL database, querying a datetime field works as expected?

Unable to convert MySQL date/time value

Posted: Tue Aug 02, 2011 9:00 am
by davidc
Each provider handles the data different, but they call usually convert the object into common types. Apparently MySQL does things slightly different when it comes to DateTime objects. Unfortunately this is a provider issue which is beyond our control. David