DateTime Fractional Seconds

DateTime Fractional Seconds

Postby jscheer » Thu 09 Jan 2014 13:37

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.
jscheer
 
Posts: 1
Joined: Thu 09 Jan 2014 13:27

Re: DateTime Fractional Seconds

Postby Shalex » Tue 14 Jan 2014 10:33

jscheer wrote: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
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44

Re: DateTime Fractional Seconds

Postby Shalex » Mon 27 Jan 2014 10:08

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
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44

Re: DateTime Fractional Seconds

Postby Shalex » Thu 30 Jan 2014 15:51

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.
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL