ADOConnection data Short Time field shows incorrect date
Posted on 2003-02-19
Am using ADOConnection in Delphi6, over an Access97 database containing Short Date and Short Time fields.
When using Access to look at data all is fine. Dates are dates alone, time is time alone.
The ADOConnection onto the same file/record set shows the correct short date (without the time) but the short time is always displayed in the DBGrid with an incorrect date, which is not needed.
Is the problem with ADO Delphi components, or with the database engine (Jet 3.5)? and how do you get around the problem?