select count(*) from dual where QSSJ<to_char(to_date('2003-8-26 1:30:00','yyyy/mm/dd hh24:mi:ss'),'hh24:mi:ss') and to_char(to_date('2003-8-26 1:30:00','yyyy/mm/dd hh24:mi:ss'),'hh24:mi:ss')<JSSJ;
where to_date('2003-08-26 13:30:00','yyyy-mm-dd hh24:mi:ss') between qssj and jssj
where
QSSJ<to_char(to_date('2003-8-26 1:30:00','yyyy/mm/dd hh24:mi:ss'),'hh24:mi:ss') and
to_char(to_date('2003-8-26 1:30:00','yyyy/mm/dd hh24:mi:ss'),'hh24:mi:ss')<JSSJ;
qssj and jssj