adoQuery1.close; adoquery1.sql.clear; adoquery1.sql.add('select * from table where riqi between :Begintime and :Endtime'); adoquery1.parameters.parambyname('BeginTime').Value := datetimepicker1.datetime; adoquery1.parameters.parambyname('EndTime').Value := datetimepicker2.datetime; adoQuery1.open;
with query1 do begin close; sql.Clear; sql.Add('select * from table where sj >=:cc and sj <=:dd '); parambyname('cc').AsString :=datetostr(datetimepicker1.date); parambyname('dd').AsString :=datetostr(datetimepicker2.date); open; end;
把上面的SQL中的sj 改成riqi
Query1.close; query1.sql.clear; query1.sql.add('select * from table1 where 日期>=:Abegintime '); query1.sql.add('and 日期<=:Aendtime'); query1.parambyname('AbeginTime').asdatetime:= datetimepicker1.datetime; query1.parambyname('AendTime').asdatetime := datetimepicker2.datetime; Query1.open;
adoquery1.sql.clear;
adoquery1.sql.add('select * from table where riqi between :Begintime and :Endtime');
adoquery1.parameters.parambyname('BeginTime').Value := datetimepicker1.datetime;
adoquery1.parameters.parambyname('EndTime').Value := datetimepicker2.datetime;
adoQuery1.open;
这样你的日期格式就是yyyy-mm-dd的格式了
begin
close;
sql.Clear;
sql.Add('select * from table where sj >=:cc and sj <=:dd ');
parambyname('cc').AsString :=datetostr(datetimepicker1.date);
parambyname('dd').AsString :=datetostr(datetimepicker2.date); open;
end;
query1.sql.clear;
query1.sql.add('select * from table1 where 日期>=:Abegintime ');
query1.sql.add('and 日期<=:Aendtime');
query1.parambyname('AbeginTime').asdatetime:= datetimepicker1.datetime;
query1.parambyname('AendTime').asdatetime := datetimepicker2.datetime;
Query1.open;