先将日期转成浮点数再去比较.
var FloatTime: Real;FloatTime:=StrToDateTime('2002-06-15 10:00:00');然后再用:'Select * from 表1 where 时间 >= '+FloatToStr(FloatTime)
var FloatTime: Real;FloatTime:=StrToDateTime('2002-06-15 10:00:00');然后再用:'Select * from 表1 where 时间 >= '+FloatToStr(FloatTime)
procedure TForm1.Button1Click(Sender: TObject);
begin
with query1 do
begin
close;
sql.Clear;
sql.Add('select * from orders where shipdate<=:rq');
parambyname('rq').AsDateTime:=strtodatetime('2002-06-15 10:00:00');
open;
end;
end;