Code: Select all
CREATE TABLE test
(
ID INTEGER PRIMARY KEY AUTOINCREMENT,
DELPHI_DTTM DATETIME
);
INSERT INTO test(DELPHI_DTTM) VALUES (43079.0);
Next, add a rule and execute the query:
Code: Select all
LiteQuery.DataTypeMap.Clear;
LiteQuery.DataTypeMap.AddDBTypeRule(liteDateTime, ftDate);
LiteQuery.SQL.Text := 'SELECT DELPHI_DTTM FROM test'
Why is that? How to get the correct date - 10.12.2017?