select * from table where datepart(m,birth)=4 and datepart(d,birth)=1
with query1 do begin close; sql.clear; sql.add('select * from table where csrq=:mr'); Parameters.ParamByName('mr').Value:=formatdatetime('mm-dd',table1.fieldvalus ['csrq']'); prepared:=true; query.open;
with adoquery1 do begin close; sql.clear; sql.add('select * from table where csrq='+quoted(formatdatetime('mm-dd',DateTimePicker1.Date)); open; end;
where datepart(m,birth)=4 and datepart(d,birth)=1
begin
close;
sql.clear;
sql.add('select * from table where csrq=:mr');
Parameters.ParamByName('mr').Value:=formatdatetime('mm-dd',table1.fieldvalus ['csrq']');
prepared:=true;
query.open;
begin
close;
sql.clear;
sql.add('select * from table where csrq='+quoted(formatdatetime('mm-dd',DateTimePicker1.Date));
open;
end;