Oracle数据库根据时间查询

select * from mini_account_log_pt_75 where account_no='30020000006446750156' 
and trans_dt between to_date('2010-12-01 00:00:00','YYYY-MM-DD HH24:MI:SS') and to_date('2011-12-31 23:59:50','YYYY-MM-DD HH24:MI:SS')

 

 

 

根据时间范围统计个数

select count(mini_trans_log_id) from mini_account_log_pt_75 where account_no='30020000006446750156' 
and trans_dt between to_date('2010-12-01 00:00:00','YYYY-MM-DD HH24:MI:SS') and to_date('2011-12-31 23:59:50','YYYY-MM-DD HH24:MI:SS')