Delphi 2009 Version 12.0.3420.21218
dbx driver for postgreSQL V3.5.7
PostgreSQL 9.3.5
My table struct:
Code: Select all
CREATE TABLE tb(
AID Integer NOT NULL,
ADateTime TIMESTAMP,
primary key(AID)
);
insert INTO tb values(1, '2014/10/01 01:01:01');
Code: Select all
SQLQuery1.SQL.Text := 'SELECT * FROM tb WHERE adatetime >= :adateTime ';
SQLQuery1.Params.ParamByName('adateTime').AsDateTime := StrToDate('2010/01/01');
SQLQuery1.Open;
Why?