where dtVtime>='2003-10-15 00:00:00' and dtVtime<='2003-10-16 23:59:59'
修改为:
where dtVtime>=to_date('2003-10-15 00:00:00','yyyy-mm-dd hh24:mi:ss') and dtVtime<=to_date('2003-10-16 23:59:59','yyyy-mm-dd hh24:mi:ss')
修改为:
where dtVtime>=to_date('2003-10-15 00:00:00','yyyy-mm-dd hh24:mi:ss') and dtVtime<=to_date('2003-10-16 23:59:59','yyyy-mm-dd hh24:mi:ss')
a.cPlateType||a.cPlateID