一个关于日期的查询

Question

var strs:string;
strs:='select *from tablename where datel>='+''''+datetimetostr(datetimepicker1.datetime)+''''+' and datel<='+''''+datetimetostr(datetimepicker2.datetime)+''''

Answer 1

With Query1 do
begin
    Close;
    Sql.Text :='Select * from Tablename Where Date1 between :sDate and :eDate';
    paramByName('sDate').AsDateTime :=Trunc(TDateTimePicker1.Date);
    paramByName('eDate').AsDateTime :=Trunc(TDateTimePicker2.Date)+1;
   Open;
end;

Answer 2

with Query1 do
begin
  Active:=False;
  SQL.Clear;
  SQL.Add('Select * From myTable Where date1 Between :pDate1 And :pDate2');
  ParambyName('pDate1').AsDateTime:=DateTimePicker1.DateTime;
  ParambyName('pDate2').AsDateTime:=DateTimePicker2.DateTime;
  Active:=True;
end;

Answer 3

strs:='select * from tablename where datel between #'+datetimetostr(datetimepicker1.datetime)+'# and # '+datetimetostr(datetimepicker2.datetime)+'#'

Answer 4

早知wolfAone(¤一步一步网上爬¤) 已经答了，我又何必多此一举

Answer 5

select * from tablename where date1>=:datetostr(datetimepicker1.date) and date1<=:datetostr(datetimepicker2.date)

Answer 6

如果有的时候返回结果不正确或为空，你再加上FormatDateTime这个东西试试