两个to_date
SELECT jl.pin ,jl.time , jl.sn as jlsn , d.sn as dsn , d.DEPT
FROM MY012KQ.KQJL jl ,MY012KQ.kq_manage d
where jl.sn = d.sn and
to_date(jl.time,'yyyy-mm-dd HH24:MI:ss')>= to_date('${''+a+' 00:00'}','yyyy-mm-dd HH24:MI')
and to_date(jl.time,'yyyy-mm-dd HH24:MI:ss') <= to_date('${''+b+' 23:59'}','yyyy-mm-dd HH24:MI')
SELECT jl.pin ,jl.time , jl.sn as jlsn , d.sn as dsn , d.DEPT
FROM MY012KQ.KQJL jl ,MY012KQ.kq_manage d
where jl.sn = d.sn and
to_date(jl.time,'yyyy-mm-dd HH24:MI:ss')>= to_date('${''+a+' 00:00'}','yyyy-mm-dd HH24:MI')
and to_date(jl.time,'yyyy-mm-dd HH24:MI:ss') <= to_date('${''+b+' 23:59'}','yyyy-mm-dd HH24:MI')