where条件中时间问题
两个数据窗口,
一个查询窗口:三个字段:起始时间,结束时间,车牌号. dw_enquiry
一个显示窗口:根据条件显示. dw_grid
string ls_truckno
datetime ldt_starttime,ldt_endtime
ls_truckno = dw_enquiry.getitemstring(dw_enquiry.getrow(),'f1_yyprd_adv_freighthd$truckno')
ldt_starttime = dw_enquiry.getitemdatetime(dw_enquiry.getrow(),'f1_yyprd_adv_freighthd$consignmentdate')
ldt_endtime = dw_enquiry.getitemdatetime( dw_enquiry.getrow(),'f2_yyprd_adv_freighthd$consignmentdate')
string bak_sqlstring,sqlstring
dw_grid.settransobject(sqlca)
bak_sqlstring = dw_grid.getsqlselect( )
sqlstring=bak_sqlstring+" where truckno='"+ls_truckno+"'
and consignmentdate>= '"+string(ldt_starttime)+"' and consignmentdate<= '"+string(ldt_starttime)+"' "
dw_grid.setsqlselect(sqlstring)
dw_grid.retrieve()
dw_grid.setsqlselect(bak_sqlstring)
dw_grid显示时根据不同车牌号可以显示,但是显示某一时间段就有问题,where条件中时间怎么写?