with ADOQuery1 do begin Close; SQL.Text:='delete from t where d between :D1 and :D2'; Parameters.ParamByName('D1').Value:=datetimepicker1.date; Parameters.ParamByName('D1').Value:=datetimepicker2.date; ExecSQL; end;
with ADOQuery1 do begin Close; SQl.Clear; SQL.Add(Format('delete from t where d >= ''%S'' and d<= ''%S'' ', [FormatDateTime('YYYY-MM-DD 00:00:00',datetimepicker1.date), FormatDateTime('YYYY-MM-DD 23:59:59',datetimepicker2.date)])); ExecSQL; end;
begin
Close;
SQL.Text:='delete from t where d between :D1 and :D2';
Parameters.ParamByName('D1').Value:=datetimepicker1.date;
Parameters.ParamByName('D1').Value:=datetimepicker2.date;
ExecSQL;
end;
begin
Close;
SQl.Clear;
SQL.Add(Format('delete from t where d >= ''%S'' and d<= ''%S'' ',
[FormatDateTime('YYYY-MM-DD 00:00:00',datetimepicker1.date),
FormatDateTime('YYYY-MM-DD 23:59:59',datetimepicker2.date)]));
ExecSQL;
end;