如何编写SQL查询语句

Question

我想编写一条查询语句,要求查出在两个DateTimePicker之间的数据,

Answer 1

select * from table where ..between ..and..

Answer 2

select data from 表 where date in (2004-7-15,2004-7-20);

Answer 3

with query1 do
 begin
    sql.clear;
    sql.add(select * from tbl where f between :p1 and :p2);
    parambyname('p1').asdatetime:=datetimepicker1.datetime;
    parambyname('p2').asdatetime:=datetimepicker2.datetime;
    close;
    open;
  end;

Answer 4

strSql:='select * from table where bDate>:bDate and eDate<:eDate ';
query.Close;
query.clear;
query.SQL.text:=strSql;
query.ParaByName('bDate').AsDate:=DateTimePicker1.DateTime;
query.ParaByName('bDate').AsDate:=DateTimePicker2.DateTime;
query.Open;
试试!

Answer 5

strSql:='select * from table where convert(char(8),bDate,112) between :VBeginDate and :VEndDate');
query.Close;
query.clear;
query.SQL.text:=strSql;
query.ParaByName('VBeginDate').Value:=FormatDateTime('yyyymmdd',DateTimePicker1.DateTime);
query.ParaByName('VBeginDate').Value:=FormatDateTime('yyyymmdd',DateTimePicker2.DateTime);
query.Open;