select * from tablename where getdate like '%-25%'
select * from table where Day(getdate) = 25select * from table where Day(getdate) >= 15 and Day(getdate) <=25
建议用2个输入begindate,enddate 查25号的也可以begindate=25,enddate=25select * from table where getdate between begindate and enddate
i:=pos(',',edit1.text); if i>0 then begin edit1.selstart:=0; edit1.sellength:=i; a:=edit1.seltext; edit1.selstart:=i; edit1.sellength:=length(edit1.text)-i; b:=edit1.seltext; end; sql.add('select * from tablename where getdate>=:s1 and getdate<=:s2'); query1.parambyname('s1').value:=strtodate('2003-7-'+a); query1.parambyname('s1').value:=strtodate('2003-7-'+b); query1.open;
查25号的也可以begindate=25,enddate=25select * from table where getdate between begindate and enddate
if i>0 then
begin
edit1.selstart:=0;
edit1.sellength:=i;
a:=edit1.seltext;
edit1.selstart:=i;
edit1.sellength:=length(edit1.text)-i;
b:=edit1.seltext;
end;
sql.add('select * from tablename where getdate>=:s1 and getdate<=:s2');
query1.parambyname('s1').value:=strtodate('2003-7-'+a);
query1.parambyname('s1').value:=strtodate('2003-7-'+b);
query1.open;