遇到个sql问题

Question

表中有个字段是 timestamp类型  格式为yyyy-MM-dd HH:mm:ss
怎么找出在区间1:00---2:00的所有数据

Answer 1

select a01,to_char(a01,'hh24:mi') from qiudf_0926
where to_char(a01,'hh24:mi') between '1:00' and '2:00'

Answer 2

select to_char(a1,'hh2:mi') t from qiuf_0926
where to_chare(a1,'hh24:mi') between '1:00' and '2:00'