Unable to convert MySQL date/time value
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.
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.
Unable to convert MySQL date/time value
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.
SAPIEN Technologies, Inc.
- gkhairallah
- Posts: 44
- Last visit: Thu Jun 15, 2023 12:55 pm
- Has voted: 2 times
Unable to convert MySQL date/time value
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?
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
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.
SAPIEN Technologies, Inc.