select * from table where datetime between formatdatetime('yyyy-MM-dd',DateTimePicker1.DateTime) and formatdatetime('yyyy-MM-dd',DateTimePicker2.DateTime)
字段名称:SendData,类型: smalldatetime,sqlStr:='select * from SendGoods where SendData between '+QuotedStr(DateToStr(datetimepicker1.date))+' and '+ QuotedStr(DateToStr(datetimepicker2.date));我这里没有delphi,可能写的有误,你自己写写,注意空格等问题!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货