select * form yourtablename where date>=2003-7-10 and date<=2003-7-20
是这样吗? select * from db where date between '2003-7-10' and '2003-7-20'
with ado do begin close; SQL.clear; SQL.add('select * from table where 日期条件>=:pdate1 and 日期条件<=:pdate2 '); paramters.parambyName('pdate1').value:=date1; paramters.parambyName('pdate2').value:=date2; open; end;
access select * from table where dt between #'2003-7-10'# and #'2003-7-11'#sql server select * from table where dt between '2003-7-10' and '2003-7-11'pardox sqlect * from table where dt>=:d1 and dt<=:d2; paramters.parambyName('d1').asstring := date; paramters.parambyName('d2').asstring := date + 1;
where date>=2003-7-10 and date<=2003-7-20
select * from db where date between '2003-7-10' and '2003-7-20'
begin
close;
SQL.clear;
SQL.add('select * from table where 日期条件>=:pdate1 and 日期条件<=:pdate2 ');
paramters.parambyName('pdate1').value:=date1;
paramters.parambyName('pdate2').value:=date2; open;
end;
select * from table where dt between #'2003-7-10'# and #'2003-7-11'#sql server
select * from table where dt between '2003-7-10' and '2003-7-11'pardox
sqlect * from table where dt>=:d1 and dt<=:d2;
paramters.parambyName('d1').asstring := date;
paramters.parambyName('d2').asstring := date + 1;