请高手分析一下,错在哪儿?在线等啊,救救我吧!

Question

select * from table1 t where callend >=to_date('20060309171612','yyyymmddhh24miss')
                             and callend <to_date('20060309172012','yyyymmddhh24miss')
                           and callerno ='136622*****' 

Answer 1

select * from table1 t where TO_CHAR(callend,'YYYYMMDDHH24MISS') >='20060309171612' and TO_CHAR(callend,'YYYYMMDDHH24MISS') <20060309172012
                           and callerno ='136622*****'