按时间段查询

select * from  t_cards where jzsj between to_date('2010-11-23','yyyy-mm-dd') and to_date('2010-11-30','yyyy-mm-dd') order by jzsj desc;