Microsoft OLEDB Provider for SQL , DateTime2 Field

[robert83 2]

Hello Everyone,

 

got here a Table with Datetime2(5) field . For example 2022-03-11 07:39:53.86286 .

 

Before I was using the MDAC SQLOLEDB Provider which comes with Windows . There this field DateTime2(5) was simply returned as WideString .

 

Now I have installed the new Microsoft OLEDB Provider for SQL ( the undeprectated one ) . And it returns Datetime2(5) in Delphi inside a ADOQUERY simply as Datetime .

 

And after playing around with the ADOQUERY Field , settings its Displayformat to : dd.MM.yyyy HH:nn:ss.zzzzz

 

I get 11.03.2022 07:39:53.862 in cxGrid . If I leave this Displayformat empty I only get 11.03.2022 07:39:53 .

 

My question is is there still a limitation with DateTime2(5) and Microsoft OLEDB Provider for SQL and Delphi ADO ?

 

Thank you

[ZDeveloper 2]

why not FireDAC?