Question

PB时间段查询

string chengba
datetime day_start
datetime day_end
day_start=datetime(date(em_1.text),time("00:00:00"))
day_end=datetime(date(em_2.text),time("23:59:29"))
chengba="t_mat_outbill_mo_outputdate>='"+string（day_start）+"' and (t_mat_outbill_mo_outputdate<='"+string（day_end）+"')"
dw_1.setfilter(chengba)
dw_1.Filter( )

老出现 types of expressions must match
我用的是PB 8.0

Answer 1

这一句：

chengba="t_mat_outbill_mo_outputdate>='"+string（day_start）+"' and (t_mat_outbill_mo_outputdate<='"+string（day_end）+"')"

改成：

chengba="(t_mat_outbill_mo_outputdate>=datetime('"+string(day_start)+"')) and (t_mat_outbill_mo_outputdate<=datetime('"+string(day_end)+"'))"