DateTime Fractional Seconds

[jscheer]

I've been using dotConnect version 8.0.17 in combination with MySQL 5.6.10 for a while. However after updating my development machine some parts of my code stopped working. The updated machine has dotConnect 8.2.65 and MySQL 5.6.15.

Two things I have noticed. First when saving a DateTime from .NET in my database there is a difference in seconds sometimes. When saving 2014-01-09 23:59:59 it sometimes becomes 2014-01-10 00:00:00.

The second thing is when I save a record with a DateTime and use the exact same DateTime to select the record again, no records are returned.

After some research I learned that MySQL supports fractional seconds since version 5.6.4. In my database I use the type DATETIME without the fractional part. DateTimes get stored as 2014-01-09 23:59:59 and not something like 2014-01-09 23:59:59.0000. I don't need and don't want to use the fractional part.

It looks like dotConnect is sending the full .NET DateTime, with milliseconds, to the database and the database is rounding the milliseconds to seconds and trying to select the DateTime according the milliseconds in stead of just the seconds.

Has there been a change in dotConnect concerning the DateTimes? If so, can you provide me with a workaround? After downgrading in my development environment to version 8.0.17 everything seems to work as expected again.

[Shalex]

It looks like dotConnect is sending the full .NET DateTime, with milliseconds, to the database and the database is rounding the milliseconds to seconds and trying to select the DateTime according the milliseconds in stead of just the seconds.

We have reproduced the issue and are investigating the possibility of implementing the option to ignore fractional seconds with the new versions of dotConnect for MySQL. We will notify you about the result as soon as possible.

[Shalex]

The IgnoreFractionalSeconds connection string parameter (default value is False) is implemented to define whether or not fractional seconds are sent to database. We will notify you when the corresponding build of dotConnect for MySQL is available for download.

[Shalex]

New build of dotConnect for MySQL 8.2.90 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=2&t=28829.