with adoquery1 do begin close; sql.clear; sql.add('select * from XXX where date>=:s_de and date<=:e_de'); parameters.ParamByName('s_de').Value:=strtodatetime('5/1/03'); //可用datetimepicker控件 parameters.ParamByName('e_de').Value:=strtodatetime('10/1/03'); open; end;
if you used paradox select × from xxx where datafield between "5/1/2003" and "10/1/2003" else if Access select X from xxx where datafile between #2003-5-1# and #2003-10-1 else if mssql select x from xxx where datafile between '2003-5-1' and '2003-10-1'
楼主最好是采纳 linghua(凌华)的代码。
adoquery1.close; adoquery1.clear; adoquery1.text:='SELECT * FROM TABLE WHERE date>='''+DATETO STR(TIME1)+''''+' AND TIME<='+DATETOSTR(TIME2)+''''; adoquery1.open;
begin
close;
sql.clear;
sql.add('select * from XXX where date>=:s_de and date<=:e_de');
parameters.ParamByName('s_de').Value:=strtodatetime('5/1/03'); //可用datetimepicker控件
parameters.ParamByName('e_de').Value:=strtodatetime('10/1/03');
open;
end;
select × from xxx where datafield between "5/1/2003" and "10/1/2003"
else if Access
select X from xxx where datafile between #2003-5-1# and #2003-10-1
else if mssql
select x from xxx where datafile between '2003-5-1' and '2003-10-1'
adoquery1.clear;
adoquery1.text:='SELECT * FROM TABLE WHERE date>='''+DATETO STR(TIME1)+''''+' AND TIME<='+DATETOSTR(TIME2)+'''';
adoquery1.open;