Delphi app, Access database: migrating from ADO to FireDAC
I’m in the process of migrating my Delphi 12 VCL windows application from MS Access database to PostgreSQL .
My first step is to migrate the provider from ADO to FireDAC.
My problem is that when reading a date-time field from the database using FireDAC the milliseconds are not preserved.
Reading the same field with ADO might produce
24-12-2024 12:00:00:123
while with FireDAC I get
24-12-2024 12:00:00:000
The issue is the same regardless of the latter field is configured as a DateTime or SQLTimeStamp.