Fractional Second Support

Jan 6, 2015 at 12:11 AM

Looks like since connector 6.5 fractional seconds from datetimes are supported. Unfortunately the resulting dump is not including these :| Would be great if this could be supported.

Jan 6, 2015 at 2:31 AM
Edited Jan 6, 2015 at 2:32 AM
Hi, can you provide examples?

A CREATE TABLE statement for the sample of table structure and an INSERT statement which demonstrates the data.
Jan 6, 2015 at 2:43 AM

drop table if exists DateTimes;
create table DateTimes (MiliDateTime DateTime(6));
insert into DateTimes (MiliDateTime) Values("2012-08-27 19:27:00.150000");

Mysqldump will output the string I'm inserting there however appears to use the default DateTime.ToString() format. I played around with the dot net connector and the .net DateTime does indeed have the miliseconds after fetching the row, so this appears to be a formatting/parsing problem.

Jan 6, 2015 at 5:17 AM
Ok, will look into this and get back later
Jan 25, 2015 at 9:58 AM
Hello, this problem is resolved in new release of V2.0.7.
The fraction seconds are now exported.