如果status是日期类型 status between to_date('2011-12-30 10:20:45','yyyy-MM-dd HH24:mm:ss') and to_date('2012-01-01 13:20:50','yyyy-MM-dd HH24:mm:ss')
select status from tablename where dateno>=to_date('2011-12-30 10:20:45','yyyy-MM-dd HH24:mm:ss') and dateno<=to_date('2012-01-01 13:20:50','yyyy-MM-dd HH24:mm:ss')
status between to_date('2011-12-30 10:20:45','yyyy-MM-dd HH24:mm:ss') and to_date('2012-01-01 13:20:50','yyyy-MM-dd HH24:mm:ss')
where dateno>=to_date('2011-12-30 10:20:45','yyyy-MM-dd HH24:mm:ss')
and dateno<=to_date('2012-01-01 13:20:50','yyyy-MM-dd HH24:mm:ss')