时间之间的比较可以用大于,小于进行比较。不可要根据哪种数据库在时间前要加一些符号。 例如在sql server中 query1.sql.add('select * from table where date>'''+DateToStr(date)+'''');
query1.sql.add('select * from table where date between :date1 and :date2' ); query1.parameters[0].value:=datetimepicker1.date; query1.parameters[1].value:=datetimepicker2.date; query1.open;
query1.sql.add('select * from table where date between :date1 and :date2' ); query1.parameters[0].value:=datetimepicker1.date; query1.parameters[1].value:=datetimepicker2.date; query1.open;
ORquery1.sql.add('select * from table where date >= '':date1'' and date <= '':date2'' ' ); query1.parameters[0].value:=datetimepicker1.date; query1.parameters[1].value:=datetimepicker2.date; query1.open;
例如在sql server中
query1.sql.add('select * from table where date>'''+DateToStr(date)+'''');
query1.parameters[0].value:=datetimepicker1.date;
query1.parameters[1].value:=datetimepicker2.date;
query1.open;
query1.parameters[0].value:=datetimepicker1.date;
query1.parameters[1].value:=datetimepicker2.date;
query1.open;
ORquery1.sql.add('select * from table where date >= '':date1'' and date <= '':date2'' ' );
query1.parameters[0].value:=datetimepicker1.date;
query1.parameters[1].value:=datetimepicker2.date;
query1.open;