where createtime between to_date('2015/11/11 1:29:24','yyyy/mm/dd hh24:mi:ss') and to_date('2015/11/11 15:29:24','yyyy/mm/dd hh24:mi:ss')试试用这样的方式
