About DATETIME with fractional seconds

[RNOVAK]

About new support to Fractional seconds in Time Values of MySQL 5.6/5.7

Since MySQL 5.6.4, there is support to DATETIME as '2014-02-02 10:05:45.123456'.

Example:
CREATE TABLE `mytest` (
`dt_hr_id` DATETIME(3) NOT NULL,
PRIMARY KEY (`dt_hr_id`)
);

Using the MyDAC... 'SELECT * from mytest;'
...
if DateTime '2014-02-02 10:05:45.123'.
ShowMessage(FormatDateTime('hh:nn:ss.zzz' ,MyQuery.Fields[0].AsDateTime));
shows '10:05:45.000' ...

I know about some limitations of Delphi, but above, why it shows '.000' ?
Is there a way to use it with MyDAC without use of MICROSECOND() of MySQL ?

Roberto

[PavloP]

Thank you for your request.
We will investigate the possibility of adding this functionality in one of the next MyDAC versions.