Unable to convert MySQL date/time value

This forum can be browsed by the general public. Posting is limited to current SAPIEN license holders with active maintenance and does not offer a response time guarantee.
Forum rules
DO NOT POST SUBSCRIPTION NUMBERS, LICENSE KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
User avatar
davidc
Posts: 5913
Joined: Thu Aug 18, 2011 4:56 am

Unable to convert MySQL date/time value

Post by davidc » Tue Aug 02, 2011 8:50 am

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
David
SAPIEN Technologies, Inc.

User avatar
gkhairallah
Posts: 31
Joined: Fri Jul 29, 2011 6:45 am

Unable to convert MySQL date/time value

Post by gkhairallah » Tue Aug 02, 2011 8:54 am

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?

User avatar
davidc
Posts: 5913
Joined: Thu Aug 18, 2011 4:56 am

Unable to convert MySQL date/time value

Post by davidc » Tue Aug 02, 2011 9:00 am

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
David
SAPIEN Technologies, Inc.