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 LICENSE NUMBERS, ACTIVATION 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.
This topic is 12 years and 7 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
User avatar
davidc
Posts: 5913
Last visit: Mon Jul 08, 2019 8:55 am
Been upvoted: 2 times

Unable to convert MySQL date/time value

Post 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
David
SAPIEN Technologies, Inc.
User avatar
gkhairallah
Posts: 44
Last visit: Thu Jun 15, 2023 12:55 pm
Has voted: 2 times

Unable to convert MySQL date/time value

Post 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?
User avatar
davidc
Posts: 5913
Last visit: Mon Jul 08, 2019 8:55 am
Been upvoted: 2 times

Unable to convert MySQL date/time value

Post 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
David
SAPIEN Technologies, Inc.
This topic is 12 years and 7 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.