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
About DATETIME with fractional seconds
Re: About DATETIME with fractional seconds
Thank you for your request.
We will investigate the possibility of adding this functionality in one of the next MyDAC versions.
We will investigate the possibility of adding this functionality in one of the next MyDAC versions.