Could params not use "AsDateTime"?
Posted: Sun 02 Nov 2014 01:28
I used:
Delphi 2009 Version 12.0.3420.21218
dbx driver for postgreSQL V3.5.7
PostgreSQL 9.3.5
My table struct:
Delphi Code is:
I get a error message:
Why?
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?